Re: I can't seem to get Max() to work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux