Re: Selecting last row
| From: | Dobromir Velev | Date: | Fri, 21 Dec 2001 13:40:38 +0000 |
| Subject: | Re: Selecting last row | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15179@lists.php.net to get a copy of this message | ||
Hi,
if you're using an auto_increment field or another field which increases with every record
(like date entered) you can use something
like
select * from table_name order by auto_field_name DESC limit 0,1
Hope this helps
Dobromir Velev
Web Developer
http://www.websitepulse.com/