Re: Finding highest number in auto increment

Oh, forget to include that if you only want that one record, use the "LIMIT 1" keyword as well. Adam Voigt adam.voigt@cryptocomm.com P.S.: All of this is in the MySQL manual. On Tue, 09 Apr 2002 15:48:45 +0200, Lisi <lists@shemeshdirectory.co.il> wrote: > Each record in my table has a unique ID number generated by auto increment > each time a new record is added. This is stored in a field called ID. I > have a page that displays records as they are selected, but I want the > default to be the latest entry if none has been selected. > > How do I write the query to find the highest number an display that record? > > It should be something like this I think: > > SELECT organization FROM ayny WHERE ID ... > > how does this end? > > Thanks, > > -Lisi > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >