Help With Combining and Totaling Arrays

mj99

I have managed to use some complex mysql queries (for me at least) to come up with this results set.

Array ( [0] => 200 ) Array ( [0] => 0 ) Array ( [0] => 0 ) Array ( [0] => 0 ) Array ( [0] => 0 ) Array ( [0] => 300 ) Array ( [0] => 600 ) Array ( [0] => 400 ) Array ( [0] => 500 ) Array ( [0] => 500 ) Array ( [0] => 500 ) Array ( [0] => 400 ) Array ( [0] => 0 ) Array ( [0] => 800 ) Array ( [0] => 200 ) Array ( [0] => 400 )

As you can see the results includes multiple arrays containing just one number. Is it possible for me to combine the results for all the arrays together into a total. For instance, the total here would be 4,800.

scrupul0us

http://us2.php.net/array_sum

HTH

mj99

Thanks anyway but if it were that simple I wouldn't be asking.

Array_sum always comes back with this.

"Warning: array_sum() [function.array-sum]: The argument should be an array"

Standard PHP functions don't cut it with this result. I thought maybe it has something to do with that the result contains 16 different arrays.

scrupul0us

process through with a for_each and sum the sums

mj99

So for a clue on how to do that should I post in the newbie area? The thing is that everything I've tried with basic PHP functions hasn't worked so far.

halojoy

you should post
your handling of the result of that MySQL query
and how you put row result into array
and also your print_r(xxxx) line

this will make it easy to help
🙂

bradgrafelman

Are these arrays in separate variables? Are they all items in a containing array?

Also, why didn't you just have MySQL give you the SUM() ?

mj99

Here's the latest. I can print the numbers but still have no idea how to show a sum. I thought this would be very simple myself. I just can't get anything to work.

$query12 = "SELECT SUM(value) FROM value LEFT JOIN horsevalue ON horsevalue.value_id = value.id WHERE horsevalue.horse_id = $horse_id AND horsevalue.value_id = ".$row['id'];
$result12 = mysql_query($query12) or die(mysql_error());
while($row12 = mysql_fetch_array($result12)){

//echo ( $row12['SUM(value)'] ) ;

print("<pre>".print_r($row12['SUM(value)'],true)."</pre>");

}

Output:

200

300

600

400

500

400

800

200

400

mj99

Just to touch on this again. PHP seems to treat is as an array for everything but getting a sum. As you can see, this basic array output does not look like a typical array. Instead it is a bunch of arrays, each containing one number. I can't figure out how to derive a sum from it.

halojoy

try this

<?php

while($row12 = mysql_fetch_array($result12)){
     // put & save all values into array $values, for each result row
     $values[] = $row12['SUM(value)'];
}


$val_sum = array_sum( $values );

echo 'Sum: ' . $val_sum;

echo "<pre>".print_r($values,true)."</pre>";

?>