The best way is to get the records ordered inverselly by the auto-increment field and then restrict the return to 5 records.
Cheers, Luis Ferro WebDev -----Original Message----- From: Jack [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de Novembro de 2001 10:02 To: Mysql List Subject: Getting to latest 5 Records Dear all I had a table which with Auto_increment, which means when i insert a record there will be a number insert to lead as the location of the record. here is my question. I was try to get the most last five records , but i don't know which query should i use? Thx Jack --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
