mySQL 查询最常见的值.显示值和计数 - mySQL query most common value. Show value and count

mySQL query most common value. Show value and count

本文关键字：显示查询常见 mySQL | 更新日期: 2023-09-27

我想查询数据库以显示列中最常见的 3 个值（TyreMan）。然后显示值和出现次数

$sqlCommand = "SELECT TyreMan, COUNT(TyreMan) AS countTyreMan 
  FROM Pictures WHERE Tyreman IS NOT NULL AND Tyreman <> 'UNKNOWN' 
  GROUP BY TyreMan ORDER BY countTyreMan ASC LIMIT 3";
$query = mysql_query($sqlCommand) or die (mysql_error()); 
while ($row = mysql_fetch_array($query)) {
$manu = $row["TyreMan"];
echo "$manu";

此刻我只是得到

value1value2value3

如何获取计数并像这样显示它？

value1 [count], value2 [count], value3 [count]

谢谢

将计数转换为字符串并将其与值连接起来。

$manu = $manu . $row["TyreMan"] .  '[' . $row["countTyreMan"] . ']';