How to get the last 5 entries from a mysql table?

I have an mysql table containg some important notes.

the problem is this: SQL it's not always writing always the last entry at the end of the table, if a free "cell" is found it will write the new entry even in the middle of the table.

So, is there anyway i can extract the last 5 entered data?

I store the "entered date" but, i have over 300,000 entries so far... and i will just slow down the database by parsing it all again and again for the "last 5 entries" ...

 

Either do it by date added or ID number. Then...

SELECT * FROM `your_table` LIMIT 0, 5

And ORDER BY if needed. Google it if you don't understand.

 

"SELECT * FROM comments LIMIT 0,5 [B]ORDER BY 'article_id' DESC[/B]"

Code (markup):

What it's wrong?

 

Try:


SELECT * FROM comments ORDER BY article_id DESC LIMIT 0,5