PHP数组总和不加所有项目

Question

这是我用来尝试计算“接收金额”列总和的代码。 invID '95' 的总数应该 = 312，但由于某种原因它只有 = 300。我不确定是什么问题。 (请参阅下面的数据库图像)。

$sql = mysql_query("SELECT amountReceived FROM payments WHERE invID='".$id."'");
$result = mysql_fetch_array($sql);
$totalPayment = array_sum($result);
$balanceDue = $invoiceTotal - $totalPayment;

Answer 1

使用 SUM() 怎么样？

$sql = mysql_query("SELECT SUM(amountReceived) FROM payments WHERE invID='".$id."'");
$totalPayment = mysql_fetch_row($sql);