On Wed, 2004-10-27 at 23:33 -0400, 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?

SELECT * FROM table ORDER BY colname DESC LIMIT 1; 

?

assuming all your column values are unique... 

-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