php/mysql posting COUNT(*) FROM 投票总数是/否

Question

我正在计算赞成票和反对票，这样我就可以为我的网站发布赞成票/反对票。这应该很容易，但我一定是在某处遗漏了一些东西，因为我没有得到返回结果。至少没有php错误。我的全部内容

$result = mysql_query("SELECT * FROM Poll");

$votes_Poll = mysql_num_rows($result);

$vote_yes = mysql_query("SELECT vote, COUNT(*) FROM Poll GROUP BY yes");
$vote_no = mysql_query("SELECT vote, COUNT(*) FROM Poll GROUP BY no");


// Display the results

echo $votes_Poll;
echo "<br>";
echo $vote_yes;
echo "<br>";
echo $vote_no;

提前致谢

Answer 1

那是因为您正在回显一个查询对象。您的每个查询都应该...

$vote_yes = mysql_query("SELECT COUNT(*) AS total FROM Poll WHERE vote = 'yes' ");
$row = mysql_fetch_object($vote_yes);

echo $row->total; //echoes out the number of yes votes