> 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
