SQL:
SELECT TableA.C, COUNT(*) FROM TableA JOIN TableB ON (TableA.C = TableB.D)
WHERE TableB.E = 1 GROUP BY TableA.C ORDER BY COUNT(*) DESC
PHP:
$result= mysql_query("SELECT TableA.C, COUNT(*) FROM TableA JOIN TableB ON (TableA.C = TableB.D)
WHERE TableB.E = 1 GROUP BY TableA.C ORDER BY COUNT(*) DESC");
while($rows = mysql_fetch_array($result))
{
echo $rows['Count']."";
}
$rows = mysql_fetch_array($result);
{
echo $rows['Count'];
}
我尝试了两种我在网上找到的不同的东西(上面).我甚至尝试过使用“mysql_fetch_array($result,MYSQL_ASSOC)”而不仅仅是mysql_fetch_array($result).
每次,我都会收到相同的错误消息:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
/home/semsemx1/public_html/x/xx.php
另外,我已经尝试过“$rows [‘COUNT’]”,但这不起作用.
任何帮助,将不胜感激.
解决方法:
你只需要给你的计数一个ALIAS
SELECT TableA.C, COUNT(*) as total
然后你可以用它来调用它
echo $rows['total']
然后我希望你记住mysql_ *函数已被弃用,所以我建议你切换到mysqli或PDO
标签:php,sql,mysql
来源: https://codeday.me/bug/20190723/1509635.html