php - 如何回显mysql查询中GROUP BY子句使用的月份？

Question

  $sql="SELECT `Variant`, COUNT(`Variant`) AS tsold, `sold_date` FROM `vehicle_sold` GROUP BY MONTH(`sold_date`), `Variant` ";  

  while($row = mysqli_fetch_array($result)) {

  echo  $row["Variant"],"--want to show month here---",$row["tsold"],"<br/>";

  }

它显示的结果是正确的，例如:

GLI A/T-- month?---1
GLI A/T-- month?---1
XLI M/T-- month?---1
GLI A/T-- month?---2
GLI M/T-- month?---2
Grande-- month?---1
XLI M/T-- month?---2
GLI A/T-- month?---2
GLI M/T-- month?---6
XLI M/T-- month?---3
GLI A/T-- month?---1
GLI M/T-- month?---4
Grande-- month?---1
GLI A/T-- month?---1

我希望它显示为:

GLI A/T-- January---1
GLI A/T-- FEB---1
XLI M/T-- FEB---1
GLI A/T-- March---2
GLI M/T-- March---2
Grande-- March---1
XLI M/T-- April---2
GLI A/T-- April---2
GLI M/T-- May---6
XLI M/T-- Jun---3
GLI A/T-- Jun---1
GLI M/T-- July---4
Grande-- July---1
GLI A/T-- July---1

Answer 1

您可以在下面使用 MONTHNAME:

SELECT `Variant`, COUNT(`Variant`) AS tsold, MONTHNAME(sold_date) AS mname FROM `vehicle_sold` GROUP BY MONTH(`sold_date`), `Variant`