Does 'select * from table order by id desc limit 1' do what you want? HTH Rich -----Original Message----- From: Afif [mailto:afif@sur.ogs-id.com] Sent: 21 November 2002 01:49 To: PHP DB Subject: Select Last row dear All, I have data and I want to get the last row of my table. how to select the last row, with the id is timestamp? and the the result will display in the prompt? sorry if my question is sound stupid, but I really confuse how to start this code -- Warm regards, Afif mailto:afif@sur.ogs-id.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
