php - Mysql查询某列的总和不显示

Question

知道为什么这不起作用吗？当我运行它时，它不显示任何内容。

$qry = mysql_query(" SELECT SUM(payment_received) AS total FROM Orders ");
   {
 $row = mysql_fetch_assoc($qry);
echo $row['total'];
}

感谢您的帮助。

Answer 1

使用以下示例更正您的代码

$qry = mysql_query("SELECT SUM(payment_received) AS total FROM Orders");
while ($row = mysql_fetch_assoc($qry)) {
{
    echo $row["total"];
}