Re: help in getting results from mysql
| From: | David Robley | Date: | Wed, 04 Jul 2001 02:37:47 +0000 |
| Subject: | Re: help in getting results from mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56105@lists.php.net to get a copy of this message | ||
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.