[Newbie] Simple stats from mysql table data
| From: | Vans Hallden | Date: | Mon, 17 May 2004 10:30:55 +0000 |
| Subject: | [Newbie] Simple stats from mysql table data | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-186398@lists.php.net to get a copy of this message | ||
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. =)