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  | [EMAIL PROTECTED]
* 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

Reply via email to