In most of the cases of web development we should play with date and time. We have to calculate between two dates and get year, months. In this tutorial I am goings to show you some of the easiest way to calculate between two dates and get year, month, day.
Mysql Date from Date return the [...]

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 [...]