getting sum of values in array 1

[curvv]

if I have 2, 6, 9, 2, 3 values in an array, how do i get the sum of all those values without knowing how many values there are?

thanx ######## CtN ########

 

[vcherubini]

Several ways. You can do it manually:

[tt]
for ($i=0; $i<count($array); $i++) {
$tot += $array[$i];
}
[/tt]

Or you can use the PHP function array_sum() like so:

[tt]
$sum = array_sum($array);
[/tt]

Hope this helps.

-Vic vic cherubini
krs-one@cnunited.com

 

[curvv]

Hi V,

When I use array_sum(); I get double the correct value.


????

######## CtN ########

 

[vcherubini]

Hmm, I am not sure. array_sum() is a new function, and if you are using an older version of PHP (like version 4.04 or 4.05, then it might be buggy).

If that doesn't work, you can always try the first way. Thats guranteed to work.

Hope this helps.
-Vic vic cherubini
krs-one@cnunited.com

 

[curvv]

Hi V,
I must be doing something wrong.
in the array i have values 11, 10, 6. The answer i get is 6.
Here's a bit of the code:
$r_queryt=mysql_query(&quot;SELECT bill_hrs FROM tbl_time WHERE user_id='$user_id' AND date >= '$from_date' AND date <= '$to_date' AND project='$projectr'&quot;

$array = mysql_fetch_array($r_queryt);

for ($i=0; $i<count($array); $i++) {
$tot += $array[$i];
} ######## CtN ########

 

[vcherubini]

Hmmm. I don't know what to say, assuming your SQL query returns a positive result.

Try printing out the values of the array first to make sure that you are getting them right and the array is populated.

You could also try something like this:

[tt]
$r_queryt=mysql_query(&quot;SELECT bill_hrs FROM tbl_time WHERE user_id='$user_id' AND date >= '$from_date' AND date <= '$to_date' AND project='$projectr'&quot;

while ($row = mysql_fetch_array($r_queryt)) {
$tot += $row['tbl_time'];
}

[/tt]

Hope this helps.

-Vic
vic cherubini
krs-one@cnunited.com

 

[inlandpac]

You are returning multiple records!

Try:

while($array = mysql_fetch_array($r_queryt)) {
     $tot += $array[$i];
}

This should work.

Chad. ICQ: 54380631

 

[inlandpac]

Oh yeah, if you are only grabbing these numbers to perform a total sum, and doing nothing else with them, you can do:

$r_queryt=mysql_query("SELECT SUM(bill_hrs) 
                       FROM tbl_time 
                       WHERE user_id='$user_id' 
                       AND date >= '$from_date' 
                       AND date <= '$to_date' 
                       AND project='$projectr'&quot;);
$array = mysql_fetch_row($r_queryt);
$total = $array[0];

and $total will contain the total of all of your numbers.

Sincerely,
Chad. ICQ: 54380631

 

[curvv]

Hi,

thanx alot V,
This worked:

while ($row = mysql_fetch_array($r_queryt)) {
$tot += $row['bill_hrs'];
}

later ######## CtN ########

 

[vcherubini]

Your welcome.

Hope I can help some more in the future.

-Vic vic cherubini
krs-one@cnunited.com