Thank you for reply. I already have 'ORDER BY year desc'.<snip>
But as I mentioned how do I get the months and day in order too on the same list.
Thank you in advance
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