RE: [PHP-DB] Last Record
| From: | John W. Holmes | Date: | Mon, 09 Dec 2002 17:19:21 +0000 |
| Subject: | RE: [PHP-DB] Last Record | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23958@lists.php.net to get a copy of this message | ||
> Is there a quick and easy way to find out the record id of the last
record
> in
> a table? I need to read the last record and let the user know what
the
> date
> of the last record added is.
SELECT date FROM table ORDER BY date DESC LIMIT 1
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/