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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]