Format and sort the dates from MySQL Database
Posted: Tue Sep 28, 2010 8:24 pm
Hi,
I have these mysql dates in a table of my database,
How can I sort them into the result below so that I can have the end user browses monthly results?
can't think of anything!
I usually use gmdate() to format the dates from mysql database, for instance,
it would great if you can give me some hint to start!
thanks,
Lau
I have these mysql dates in a table of my database,
Code: Select all
2010-07-16 20:09:06
2010-08-16 20:19:43
2010-10-18 16:57:19
2009-09-18 16:57:42
2009-10-18 16:57:55
2009-12-24 14:59:21Code: Select all
<h2>2010</h2>
<ul>
<li><a href="#">October</a></li>
<li><a href="#">November</a></li>
<li><a href="#">December</a></li>
</ul>
<h2>2009</h2>
<ul>
<li><a href="#">September</a></li>
<li><a href="#">October</a></li>
<li><a href="#">November</a></li>
<li><a href="#">December</a></li>
</ul>I usually use gmdate() to format the dates from mysql database, for instance,
Code: Select all
<?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']));
?>thanks,
Lau