> UPDATE ngc_polling SET lastrundate =
> max(nuke_phpbb_posts.post_time)
>
> It returns "Invalid use of group function."
>
John, you're getting that error message because the
max() function requires a GROUP BY clause.
Try this:
SELECT max(nuke_phpbb_posts.post_time)
FROM nuke_phpbb_posts
GROUP BY nuke_phpbb_posts.post_time;
=====
~Rachel
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
