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
