Re: help in getting results from mysql
| From: | Christian Dechery | Date: | Tue, 03 Jul 2001 14:30:50 +0000 |
| Subject: | Re: help in getting results from mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-55987@lists.php.net to get a copy of this message | ||
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