Can you reverse your sorting order? In that case, the last row now becomes the first--making things much easier and faster! :-) Marco -- ------------ php|architect - The magazine for PHP Professionals The monthly worldwide magazine dedicated to PHP programmers Come visit us at http://www.phparch.com! On Wed, 2002-11-20 at 20:48, Afif wrote: > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php