> > John, you're getting that error message because the > max() function requires a GROUP BY clause. > Ooops, my bad. It requires a GROUP BY if you are pulling from more than one column. ===== ~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