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 />
";
}
mysql_free_result($result);
}
Tag Archive for order
Posts by month
Ordering multiple SELECT statements in a UNION
(SELECT a FROM t1 WHERE a=10 AND B=1) UNION (SELECT a FROM t2 WHERE a=11 AND B=2) ORDER BY a LIMIT 10;
Add Column After Another Column SQL
alter table `table_name` add column new_column_name float after existing_column