目前,我得到了以下代码:
$forummost = mysql_query("
SELECT door,
COUNT(door) AS doorCount
FROM forum_posts
GROUP BY door
ORDER BY COUNT(door)
DESC
");
$forummostc = mysql_num_rows($forummost);
$forummostf = mysql_fetch_assoc($forummost);有人能解释一下为什么mysql_num_rows($forummost)不起作用吗?
提前感谢!
发布于 2012-04-10 19:41:36
按组只选择mysql中该列的不同值。在您的示例中,正如所指出的,它选择的行数与不同的door值相同。
发布于 2012-04-10 19:36:47
mysql_num_rows计算查询返回的行数。您的查询是what is the count for each door,因此每个门只返回一行。
发布于 2012-04-10 19:43:41
试试看,我测试过了,效果很好..
<?php
$link = mysql_connect('localhost','root','');
if (!$link)
{
die('Could not connect to MySQL: ' . mysql_error());
}
echo 'Connection OK'."</br>";
$forummost = mysql_query("
SELECT door,
COUNT(door) AS doorCount
FROM forum_posts
GROUP BY door
ORDER BY COUNT(door)
DESC
");
$forummostc = mysql_num_rows($forummost);
if ($forummostc == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
while ($row = mysql_fetch_assoc($forummost)) {
echo $row["door"];
echo $row["doorCount"];
}
mysql_free_result($forummost);
mysql_close($link);
?> https://stackoverflow.com/questions/10095132
复制相似问题