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?
. [ Christian Dechery ]
. Webdeveloper @ Tá Na Mesa!
. Listmaster @ Gaita-L
. http://www.tanamesa.com.br
--
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]
