Last 20 objects

programming
1

Hello,

I have a tiny own created webshop and i want to add a new function.
I want to add the function "new product. When people click on the link "new products they see the 20 latest new products.

My database with products has a id value for every product.

Now i want to look up the 20 latest products in the database. So if the latest id is for example 752, it should calc 752 - 20. So in theory it must show till product 732 but taking care of when a product has been deleted (for example product 755)

How could i fix this ?

2

SELECT * FROM products ORDER BY id DESC LIMIT 20;