userxöa userxöa - 1 year ago 39
SQL Question

In Paging how to show items with bigger ID first

I use on my website paging script from .
What I should do if I'd like to see first data that has bigger ID number in database?

Answer Source

in sql? use the order by keyword and with desc you can sort it descending:

select ... from ... where ... order by ID desc