Finding highest number in auto increment
| From: | Lisi | 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