On Wed, 4 Jul 2001 00:00, Christian Dechery wrote:
> well... I tought of that.
> It doesn't work for many reasons:
> 1 - '*' always has to be the first on the select list
> 2 - you can't have expressions (max, min, avg) without a group by
> clause if you are handling multiple rows
> 3 - etc. etc.. etc...
>
> that's why I included the code in between the queries...
>
> >Try
> >
> >$rs1=mysql_query("select max(date) AS latest, * from tablename where
> >item_id=34 and item_type_id=3");
> >
> >but consider that you may possibly have multiple entries for the
> > latest
> >
> >date?
Of course, had forgotten that. I think maybe you want UNION.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
He's not dead, Jim, he's just metabolically challenged.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
