Simple question I think
When I sort something (using mysql) it comes out like:
sort1
sort2
sort3
But I want it to sort like:
sort3
sort2
sort1
How can I do this?
Sort question (mysql)
Moderator: General Moderators
- johnperkins21
- Forum Contributor
- Posts: 140
- Joined: Mon Oct 27, 2003 4:57 pm
Use this instead:
That DESC in there is what you need. Check out http://dev.mysql.com/doc/mysql/en/SELECT.html for more info.
Code: Select all
<?php
mysql_query("SELECT * FROM Table ORDER BY ColumnID DESC");
?>