RE: [PHP-DB] I can't seem to get Max() to work
| From: | Bastien Koert | Date: | Thu, 28 Oct 2004 13:00:02 +0000 |
| Subject: | RE: [PHP-DB] I can't seem to get Max() to work | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37065@lists.php.net to get a copy of this message | ||
is it an iteger type datafield?
bastien
From: "Chris Payne" <cjp@planetoxygene.com> To: <php-db@lists.php.net> Subject: [PHP-DB] I can't seem to get Max() to work Date: Thu, 28 Oct 2004 01:05:46 -0400 Hi there everyone, I cant seem to get the below to work with PHP and MySQL: $sql = "SELECT MAX(FoodItemNumber) FROM menuitemsubs"; What am I doing wrong? I need the highest number from the column FoodItemNumber, but it doesnt return anything unless I change the MAX() to a * and I dont want that I need it to be the MAX() number as it isnt an auto-increment field. Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004