Re: [PHP] [Newbie] Simple stats from mysql table data

[Vans Hallden]

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?
--

--
Hans Vallden
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] [Newbie] Simple stats from mysql table data

[Vans Hallden]

Please try to endure my ignorance. I'm new to PHP4 and out to perform 
just a single isolated task with it. :)

I would like to form some simple statistics from specific column data 
in a mysql database and display those stats on a webpage.

I have collected a few demographics from certain respondents. These 
are sex, age, and usage of our service (individual/company). The 
responses are store in a mysql 3 database.

Basically, I would like to show:
total headcounts and percentages for 'male' and 'female' respondents 
(database column 'sex')

average ages for male/female respondents (database column 'age')
usage percentages for male/female respondents (database column 'usage')
I would very much appreciate if someone could point me to eg. code 
examples helping me to accomplish this task. Unless someone wants to 
just give away their utmost expertise and send me working code, which 
would leave me absolutely speechless from respect and gratefulness. =)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php