I can't seem to get Max() to work
| From: | Chris Payne | Date: | Thu, 28 Oct 2004 05:05:46 +0000 |
| Subject: | I can't seem to get Max() to work | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37060@lists.php.net to get a copy of this message | ||
Hi there everyone,
I can’t 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 doesn’t return anything unless I change the MAX() to
a * and I don’t want that I need it to be the MAX() number as it isn’t 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