PHP array sum not adding up all items

Question

This is my code that I am using to try and calculate the sum of "amountReceived" column. The total for invID '95' should = 312, but for some reason it is only = 300. I am not sure what the issue is. (please see the DB images below).

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

enter image description here

Because you only fetched one row...

nickb
– nickb

2012-07-17 01:42:32 +00:00
Commented Jul 17, 2012 at 1:42 — nickb
– nickb, Commented Jul 17, 2012 at 1:42

sel · Accepted Answer · 2012-07-17 01:36:24Z

7

How about using SUM()?

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

answered Jul 17, 2012 at 1:36

sel

4,9421 gold badge18 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

m_gunns Over a year ago

I tried this before and it is not working. I am just not sure what the issue is.

Community · Accepted Answer · 2017-05-23 11:53:32Z

3

well the mysql_fetch_array($sql) returns an array containing all "columns" of one row you fetched, means you get an e.g. array('amountReceived'=>150)

this should work:

$sql = mysql_query("SELECT amountReceived FROM payments WHERE invID='".$id."'");
$totalPayment = 0;
while($result = mysql_fetch_array($sql)) {
    $totalPayment += $result['amountReceived'];
}
$balanceDue = $invoiceTotal - $totalPayment;

this is just a php side description of the problem, if you want to be more efficient, use sel's version ;)

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Jul 17, 2012 at 1:41

r3bel

1,3708 silver badges12 bronze badges

1 Comment

Fluffeh Over a year ago

It would be much more efficient to use the aggregate functions within the database to get the totals needed.

Bailey Parker · Accepted Answer · 2012-07-17 01:39:03Z

0

Don't use mysql_* functions - use MySQLi or PDO.
print_r($result); to see if there's something inside.

edited Jul 17, 2012 at 1:39

Bailey Parker

15.9k5 gold badges58 silver badges93 bronze badges

answered Jul 17, 2012 at 1:37

Roman Newaza

11.8k12 gold badges65 silver badges94 bronze badges

1 Comment

Bailey Parker Over a year ago

Don't forget you can inline code highlight with the backticks (`) and link to useful resources

Collectives™ on Stack Overflow

PHP array sum not adding up all items

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related