PHP和MySQL - 显示数据库中最后十个条目的最有效方法？

Question

So I have a database, and I would like to display the last ten entries.

So far I have tried several ways but run into a couple of issues. I have tried using a for-loop starting at the row count for the database and linking that to the ID, but then of course should I delete an entry the iterations will have data missing. For example if I have deleted lots of entries and have the first entry start at id 20 then if there are only 10 rows it will look to display 10 to 1, which don't exist.

Any thoughts?

Answer 1

You could try, depending on your implementation,

SELECT * FROM `table_name` WHERE conditions ORDER BY `id` DESC LIMIT 10;