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:

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. mysql_query(

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; > > $pre

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 t

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 ge

[PHP] Using MySQL user variables in PHP

2003-01-26 Thread Jim MacCormaic
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 burd