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 presenters WHERE
> > > date=@most_recent;
> > >   $presenterQuery = "
> > >           SELECT date_format(p.date, '%d/%m/%y') AS
> >
> > readable_date, p.theme,
> >
> > > p.presenter,
> > >           c.itemNo, c.composer, c.composition, c.note
> > >           FROM presenters p, compositions c
> > >           WHERE p.date = c.date AND p.presenter = @recent_presenter
> > >           ORDER BY p.date DESC";
> >
> > You're not doing anything with $tempQuery1 & $tempQuery2 this is complete
> > nonsense ;-)
>
> Not true - this is using MySQL's variable approach. The '@xxxx' represents
> a user variable per connection in MySQL. See
> http://www.mysql.com/doc/en/Variables.html for more information.

I know. The important point is that although $tempQuery1 & $tempQuery2 are 
assigned, they aren't being passed to any mysql_query().

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/*
Music in the soul can be heard by the universe.
                -- Lao Tsu
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to