Counting the values of an array

[jamessy]

Hi does any body know what the best way to loop through an array and add int values ? Basicly I am gathering info from a database, I am then using a foreach loop to loop through the array and then trying to find a way to add all the int values of the returned data together like 1+4+6 etc.
Any help would be grateful

[zalucius]

I'm assuming you're using a MySQL database.
You can add up the values directly in the SQL query:

SELECT SUM(the_field) AS summed_value FROM TABLE_NAME

This will give you one value in the result: "summed_value" which is all the "the_field" added together.

A quick PHP example:

$result= mysql_query('SELECT SUM(the_field) AS summed_value FROM table_name');
$data = mysql_fetch_assoc($result);
echo  $data['summed_value'];

[jamessy]

Perfect, might have learn more mysql!! Thanks

[jamessy]

Sorry one more thing, basicly I am building a rating system and thats why I needed to add up the values but I now need to find an average amount, is the a way I can do this in mysql?

[zalucius]

SQL also have an AVG() function, which gets the avarage of a collection of values.
Just replace the SUM() with AVG() and see what happens

[jamessy]

Perfect, again thank you

[danNL]

if the values didn't already exist in a db or you don't want to add the slight overhead of an additional query ... try php

Google search term "php sum array values"