Display Last 200 mysql entries no dupes

Question

I'm just wondering how I could display my last 200 mysql entries in php without showing duplicate entries.

Answer 1

How about something like SELECT DISTINCT * FROM table ORDER BY id DESC LIMIT 200

See this example on how to implement it in PHP.

Answer 2

Have a look at What’s the most efficient way to select the last n rows in a table without changing the table’s structure? and combine wiht DISTINCT