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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to