Re: Help for code to 'sort list' please
| From: | John Nichel | Date: | Mon, 02 Feb 2004 19:44:04 +0000 |
| Subject: | Re: Help for code to 'sort list' please | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176603@lists.php.net to get a copy of this message | ||
EastLothianDirectory wrote:
Thank you for reply. I already have 'ORDER BY year desc'. But as I mentioned how do I get the months and day in order too on the same list. Thank you in advance <snip>Read the documentation for ORDER BY in MySQL. You can sort on multiple columns. Basically, you can 'ORDER BY year, month, day DESC' (my syntax may be off), and it order it by the year first, then like years will be ordered by month, etc. -- By-Tor.com It's all about the Rush http://www.by-tor.com