I'm assuming you're IDs are getting bigger, so how about ordering them in
descending order?
SELECT ID, title, article FROM news ORDER BY ID DESC LIMIT 2
Also, if you're starting from 0, you don't need to include that in the LIMIT
clause.
--jeff
- Original Message -
From: "Todd W" <[EMAI
At 22:07 -0600 3/14/03, Todd W wrote:
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 hel
