Re: Finding the highest number in a column?

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

 



On Thu, 28 Oct 2004 13:03, Chris Payne wrote:

> Hi there everyone,
> 
>  
> 
> I am working with a very complex system where not all numbers are assigned
> 1, 2, 3 ?? etc ?? so there could be a row with the number 1 and then the
> next row could be 40 and so on ??
> 
>  
> 
> Is there a way with PHP and MySQL to find out what the highest number is
> in a particular column easily when the numbers are auto-incremented so
> aren?t necessarily one after the other?
> 
>  
> 
> I would really appreciate any help on this as it?s really bugging me.
> 
>  
> 
> Chris

Does SELECT MAX(column) do what you want?

-- 
David Robley

Me know gammar. Me cood use it gud.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


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

  Powered by Linux