On Thu, 2004-10-28 at 01:05 -0400, Chris Payne wrote: > 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. Is this an integer field? -Robby -- /*************************************** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | robby@xxxxxxxxxxxxxxx * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting & Development * --- Now supporting PHP5 and PHP4 --- ****************************************/
Attachment:
signature.asc
Description: This is a digitally signed message part