PHP: Format and sort the dates from MySQL Database

[reza1217]

I have these mysql dates in a table of my database,\[code\]2010-07-16 20:09:062010-08-16 20:19:432010-10-18 16:57:192009-09-18 16:57:422009-10-18 16:57:552009-12-24 14:59:21\[/code\]How can I sort them into the result below so that I can have the end user browses monthly results? \[code\]<h2>2010</h2><ul> <li><a href="http://stackoverflow.com/questions/3818159/#">October</a></li> <li><a href="http://stackoverflow.com/questions/3818159/#">November</a></li> <li><a href="http://stackoverflow.com/questions/3818159/#">December</a></li></ul><h2>2009</h2><ul> <li><a href="http://stackoverflow.com/questions/3818159/#">September</a></li> <li><a href="http://stackoverflow.com/questions/3818159/#">October</a></li> <li><a href="http://stackoverflow.com/questions/3818159/#">November</a></li> <li><a href="http://stackoverflow.com/questions/3818159/#">December</a></li></ul>\[/code\]can't think of anything! I usually use gmdate() to format the dates from mysql database, for instance,\[code\]<?php $sql = " SELECT * FROM root_pages WHERE root_pages.pg_hide != '1' ORDER BY pg_created DESC";#instantiate the object of __database class$object_items = new __database(DB_HOST,DB_USER,DB_PASS,DB_NAME);$items = $object_items -> fetch_all($sql);echo gmdate('j/n/Y', strtotime($item['pg_created']));?>\[/code\]it would great if you can give me some hint to start!thanks,Lau