Re: select * on all current?
| From: | Lester Caine | Date: | Tue, 27 Jul 2004 07:04:01 +0000 |
| Subject: | Re: select * on all current? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191944@lists.php.net to get a copy of this message | ||
Louie Miranda wrote:
now its working, i was wondering if we can do max(dateposted) on update?WHERE dateposted = max(dateposted); Perhaps ( works in Firebird :) ) -- Lester Caine ----------------------------- L.S.Caine Electronic Servicesmysql> update datafiles set status = '1' where max(dateposted); ERROR 1111: Invalid use of group function