averaging help

[conor.higgins]

Hi,

 

can anyone help me in getting the average of the sum of a number of tables in my DB?

I have the SELECT code grabbing what I need, and all the data is numeric so I am wondering whether it is possible to grab the data and then perform an average on the information contained within it.

 

Conor

[jcbones]

Well, we could guess what the data is. Or, how you want the averaging to happen.  Simple as it gets.

$count = 0;
while($row = mysql_fetch_assoc($namelessTablewithWhoKnowsWhatKindOfData)) {
//How many entries are there.
++$count;
//The sum of the column you want averaged.
$sum += $row['columnIwantToaverage'];
}
$average = round($sum / $count);

 

Of course, if it was a little clearer, then we could use some MySQL functions to speed up the process.

[ignace]

SELECT avg(column) FROM table