I have a doubt here, Is there any way you can tell MySQL to Align or Sort out rows from the newest to the oldest, for an Example I created 2 rows in my Database the First one Hi World And the second one Hello World,Instead of showing from the latest It show's it alpabatically But I want It to show from the newest to the oldest How to have That kind effect? I've even tried using SELECT * FROM pages ORDER BY postID ASC
but It does not Work! Please help me.
the Browse tab of the pages table:
the Structure tab of the pages table:
Use
to show the latest first (ASC is ascendent)
If you order them by
postID ASC
, it's from the smallest to the biggest one. The smallest one will be the oldest one, so this is not what you want.Change the
ASC
byDESC
, and it should work.