averages

[LordRogaine]

I'm using php with mysql. Does anyone know the proper code to get a mathematical average?

Example: 5+5+5=15 (divide this by three) the average will equal "5"

Thanks,
Lord Rogaine

[eli03]

$subt=(5+5+5)/3;
echo $subt;

[drew010]

if you are talking about getting the average from a set of data in mysql, it provides a built in function avg to calculate averages from result sets.

here is an example:

SELECT avg(COLNAME) FROM table;

it will return the average of all the numeric data in COLNAME.

if you want to do it in php, basically you have to keep a counter of how many numbers you have added and once you finish the addition, divide by the number in the counter.

[LordRogaine]

Thank you!!