Dear Jack, If (date/time) field means the last time updated or inserted, how about this; "select * from [the table] order by (date/time) desc limit 1, 5;"
-----Original Message----- From: Jack [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 6:05 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: How to retrieve the lastest update or insert record? Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
