Finding highest number in auto increment

From: Date: Tue, 09 Apr 2002 13:48:45 +0000
Subject: Finding highest number in auto increment
Groups: php.db 
Request: Send a blank email to php-db+get-18349@lists.php.net to get a copy of this message
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

« previous php.db (#18349) next »