Averages with PHP

[Romanity]

Right... heres what I got so far

$mean = array( 2, 4, 6, 8 );
$mean = array_sum($mean);
$mean = $mean/4;
echo "$mean"; 

Which does give 5 as the answer
Problem is i cant remember how to get the array from the database :S

$mean = array( ALL DATABASE VALUES); 

Is what I need.... whats the function??? :S

[MrCraig]

$sql = mysql_query("select * from YOURDATABASETABLENAME");
$mean = mysql_fetch_array($sql); 

[Romanity]

Swear i tried that
O well my bad (A)
Cheers

[Baving]

MySQL has a built in average function avg() you may use.

http://dev.mysql.com/doc/refman/5.0/...l#function_avg

[Jackboy]

MySQL has a built in average function avg() you may use.

http://dev.mysql.com/doc/refman/5.0/...l#function_avg

Php pro ^

I never knew about that site/function, cheers

[Romanity]

Cheers Alan