Re: [PHP] Using MySQL user variables in PHP

2003-01-26 Thread Jason Wong
On Monday 27 January 2003 01:51, Jim MacCormaic wrote: I'm currently developing a PHP/MySQL project, one aspect of which involves displaying a default set from the database which picks out all records for whichever individual is associated with the most recent date. I know this is a very

RE: [PHP] Using MySQL user variables in PHP

2003-01-26 Thread John W. Holmes
I'm currently developing a PHP/MySQL project, one aspect of which involves displaying a default set from the database which picks out all records for whichever individual is associated with the most recent date. I know this is a very general description, but I don't think it's necessary to

RE: [PHP] Using MySQL user variables in PHP

2003-01-26 Thread Mark Charette
-Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] 2. $tempQuery1 = SELECT @most_recent:=MAX(date) from presenters; $tempQuery2 = SELECT @recent_presenter:=presenter FROM presenters WHERE date=@most_recent; $presenterQuery =

Re: [PHP] Using MySQL user variables in PHP

2003-01-26 Thread Jim MacCormaic
On Sunday, January 26, 2003, at 06:26 pm, Jason Wong wrote: You're not doing anything with $tempQuery1 $tempQuery2 this is complete nonsense ;-) Bowing obsequiously, suitably chastened, I read on . . . This is getting closer. Unfortunately you haven't been reading the manual.

Re: [PHP] Using MySQL user variables in PHP

2003-01-26 Thread Jason Wong
On Monday 27 January 2003 02:36, Mark Charette wrote: -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] 2.$tempQuery1 = SELECT @most_recent:=MAX(date) from presenters; $tempQuery2 = SELECT @recent_presenter:=presenter FROM