$query = "select count(*)
from relationships
where leader = 'user_id'";
$result = mysql_query($query);
如何显示数量?谢谢。
$count = mysql_fetch_array($result);
echo $count[0];
$abc="SELECT count(*) as c FROM output WHERE question1=4";
$result=mysqli_query($conn,$abc);
if($result)
{
while($row=mysqli_fetch_assoc($result))
{
echo $row['c'];
}
}
它完全工作,它计算列中数字4出现的次数
$query = "SELECT COUNT(*) AS total FROM table"; $result = mysql_query($query); $values = mysql_fetch_assoc($result); $num_rows = $values['total']; echo $num_rows;查询 = "SELECT COUNT(*) AS 总数 FROM 表格"; 结果 = mysql_query(查询); 值 = mysql_fetch_assoc(结果); 行数 = 值['总数']; echo 行数;
$row = mysql_fetch_array($result)
并通过索引 0 访问:$row[0]$row = mysql_fetch_assoc($result)
并通过名称访问:$row['cnt']