Posts by month

function monthNewsList() {
 
	$query = "SELECT COUNT(id) total, MONTHNAME(date) month, YEAR(date) year ";
	$query .= "FROM news ";
	$query .= "GROUP BY MONTH(date), YEAR(date) ";
	$query .= "ORDER BY date ";
	$result = mysql_query($query);
	$count = mysql_num_rows($result);
 
	while ($row = mysql_fetch_assoc($result)) {
		echo $row["month"].' '.$row["year"].' ('.$row["total"].")<br />\n";
	}
	mysql_free_result($result);
 
}