Adding the values within an array

[Dave_Richards]

Hey all!

was wondering if you could help me with my problem. I have the following code:

Function within a class file:

[code]public static function getSomething($database){
    $query = "SELECT important FROM tblPurchases WHERE purchase = 3 AND buyer = 5";
 
    $result =  $database->Select($query);
    return $result;
  }[/code]

PHP Web Page:

[code]$function= pFunction::getSomething($_DATABASE);

foreach($function as $result) {
$important = $result;

$count++;
}[/code]

This code counts the amount of records that match the SQL criteria and places the important variable into an array. However I would like to extract all values of "important" (which is an integer value) and add them together to produce a sum of all of the "important" values. Could somebody please advice me as to what I need to add to my code to acheive this.

Thanks

[Psycho]

[code]
foreach ($arrayVar as $value) {
    $sum += $value;
}[/code]

[Dave_Richards]

thanks for your help mate :) much appreciated.

Will give the code a go tomorrow.

Thanks again

[roopurt18]

Make sure you initialize $sum before you start the loop to zero!