I am having troubles with queries, selecting only the newest records.
Select ID,title,article From news ORDER BY ID LIMIT 0,2
I tried this but it always shows the first two records and I want to select the last two records(newest ones added). Can someone help out?
Sort in descending order.
... ORDER BY ID DESC LIMIT 0, 2
By the way, LIMIT 2 is the same as LIMIT 0, 2.
Thanks
--------------------------------------------------------------------- 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