Re: [Newbie] Simple stats from mysql table data

Vans Hallden wrote:

Here is one way: (probably not the best)

I was able to get almost everything working with your help. Thanks!!! :)

average ages for male/female respondents (database column 'age')

SELECT AVG(age) FROM tablename WHERE sex = 'male'; SELECT AVG(age) FROM tablename WHERE sex = 'female';

I have one small problem remaining. With this code: $male_average_age = mysql_query("SELECT AVG(age) FROM my_database WHERE sex = 'M'"); ..I get a strange "Resource id#10" output. I can't figure out why. What am I missing?

You need to fetch the results. http://www.php.net/mysql_fetch_assoc for example.