I have a blog and I want to setup archive links for my entries split up by month. My first thought on how to do this would be to use an IF condition with my date timestamp for each entry, but I'm using a DATE_FORMAT function in my query to format the date like this:
PHP Code:
$query ="SELECT entryid, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y %T') AS date";
$query.=" FROM blog ORDER BY entryid DESC LIMIT 10";
$result=mysql_query($query);
How ideas on how best to go about setting this up?
