select MAX(colname) from table; Cheers Simon
-----Original Message----- From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 09:29 To: [EMAIL PROTECTED] Subject: [PHP] Getting the highest number in a column Using PHP and a MySQL database, I want to grab the highest number in a particular column. Right now I have this VERY inefficient code to grab this number, there's got to be a better way. Does anyone have any ideas?? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
