Louie Miranda wrote:
now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted); ERROR 1111: Invalid use of group function
WHERE dateposted = max(dateposted); Perhaps ( works in Firebird :) )
-- Lester Caine ----------------------------- L.S.Caine Electronic Services
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
