In this tutorial I am going to show you very easy way to show your post Archieves. Just Writting a simple query you can create your archieve.
THE QUERY:
<?php
$query=”SELECT MONTH(fieldname)MONTH, MONTHNAME( fieldname)MONTHNAME, YEAR(fieldname )year FROM tablename GROUP BY MONTH(fieldname) , YEAR(fieldname) ORDER BY fieldname”;
//change your fieldname and tablename
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
}
?>
Now you will fetch records and above query [...]