php - 选择数据库中条目最多的类别

Question

我已经到了可以显示每个类别中有多少条目的计数的阶段。它回显的数据是这样的

There are 6 in the category number1
There are 4 in the category number2
There are 1 in the category number4
There are 1 in the category number5
There are 1 in the category number8

但是我只想显示最受欢迎的类别。因此，例如 - 最受欢迎的类别编号是“”和“”条目

代码:

- $count_query_v1 = "SELECT categoryNo, COUNT(entryNo)
FROM entries
GROUP by categoryNo;
";

$answer = mysql_query($count_query_v1) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($answer)){
echo "There are ". $row['COUNT(entryNo)'] ."in the category number". $row['categoryNo']    ." ;

}

我该怎么做？

Answer 1

定义“最受欢迎”。如果您的意思是最受欢迎的类别是包含最多条目的单个类别，那么这将是您的查询:

SELECT categoryNo, COUNT(entryNo) as numEntries
FROM entries
GROUP by categoryNo
ORDER by numEntries DESC
LIMIT 1