PHP calculates average?

[lickuid]

Does anybody have a [short smart] script for calculating average from MySQL database columns? Thx for great help!

//lickuid//

[justageek]

Use the mysql avg.

select avg(Price) from wherever where whatever

or select avg(Price) as a from wherever where whatever

the second will return a variable called 'a' with the value in it so you can go do something with it if you wish.

Mysql is much faster than doing any kind of calculations in the result set with php.

[jonknee]

If for some reason you needed to do it in PHP, it's not hard (but as it has already been pointed out that it is much slower):

<?php
//must already be connected to MySQL
$r = mysql_query("SELECT * FROM table");
$num = mysql_num_rows($r);
while($data = mysql_fetch_array($r)) {
 $total = $data['column'] + $total;
}
$avg = $total / $num;
echo $avg;
?>