find the sum of column values

say i have this table, fusion_hiscores. one of the field values for each row in this table is "player_cmb" i want to find all the values for player_cmb, say 1 row is 110 and the next row is 20, and another one is 120. that is the only 3 in the table, so i want a function that finds all these values no matter how many rows exist, and then add them all together. how would i go about doing this? this is what i am trying:

Code:

<?php

$input = dbresult(dbquery("SELECT player_cmb FROM ".$db_prefix."hiscores"), 0);

function cmb_average($input) {
return array_sum($input) / count($input);
}
echo cmb_average();
?>

here is revised code that is returning 120 as the cmb_average, when 120 and 110 are the only 2 values in teh database, so the avg should be 115 :S

Code:

<?php
$input = dbarray(dbquery("SELECT player_cmb FROM ".$db_prefix."hiscores"));
function cmb_total($input) {
return array_sum($input);
}
function cmb_average($input) {
return array_sum($input) / count($input);
}
echo cmb_average($input);
echo cmb_total($input);
?>

[Free WordPress Themes]

try the function AVG() from the mysql manual

when i do that it gives me the call to undefined function error... how would i define this as a new function?

check out this link: http://forums.devarticles.com/php-development-48/calculate-average-in-php-6934.html

this is what i got but it doesnt show anything :S

Code:

<?php
$cmb_avg = dbquery("SELECT count(player_id) as player_id, SUM(player_cmb) as player_cmb, (SUM(player_cmb)/count(player_id)) as combat_avg FROM ".$db_prefix."hiscores");
$combat_average = dbarray($cmb_avg);
echo $combat_average;
?>

i have found the solution.. if anyone wants solution for finding average of particular columns of data let me know

[Promote your blog for free....]

If you want the average, then the solution is:

SELECT AVG(field) FROM table

If you want the summary then :

SELECT SUM(field) FROM table

[Guest]

[35.587]

Googlebot, Yahoo crawler, vbignacio