is it an iteger type datafield?


From: "Chris Payne" <[EMAIL PROTECTED]>
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 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.


--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ( Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to