php - 当按月和年对 MYSQL 查询进行分组时，如何按月而不是按字母顺序对数据进行排序？用 PHP 编写

Question

$Y = mysql_query("SELECT Year, Month, SUM(Amount) FROM farm_exp WHERE 
Client_Id='" . $_SESSION["id"] . "' && Flock_Id='" . $_SESSION["f_id"] . "' 
GROUP BY Year, Month " , $connection) or die("Query failed : " . mysql_error()); 

while($row = mysql_fetch_array($Y)){
    $monthly[] = $row;
}

此查询生成正确的数据，但顺序是按字母顺序排列，而不是实际按月份排列。按年份排序就可以了。

我得到:

2015 Dec €2000
2016 Apr €1000
2016 Feb €1200
2016 Jan €800
2016 Mar €2100

但我想要:

2015 Dec €2000
2016 Jan €800
2016 Feb €1200
2016 Apr €1000
2016 Mar €2100

Answer 1

使用这个

ORDER BY `year`, MONTH(STR_TO_DATE(`month`, '%b'))