RE: [PHP] Getting the highest number in a column
| From: | Simon Taylor | Date: | Tue, 15 Oct 2002 07:36:06 +0000 |
| Subject: | RE: [PHP] Getting the highest number in a column | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-119988@lists.php.net to get a copy of this message | ||
select MAX(colname)
from table;
Cheers
Simon
-----Original Message-----
From: Phil Schwarzmann [mailto:phil@filanya.com]
Sent: 15 October 2002 09:29
To: php-general@lists.php.net
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!