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

2004-05-18 Thread Burhan Khalid
Vans Hallden wrote: 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

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

2004-05-18 Thread 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

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

2004-05-18 Thread Burhan Khalid
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 =

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

2004-05-18 Thread Torsten Roehr
Vans Hallden [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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

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

2004-05-17 Thread 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

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

2004-05-17 Thread Matt Matijevich
[snip] I would very much appreciate if someone could point me to eg. code examples helping me to accomplish this task. [/snip] Google and http://www.php.net/ are going to be your best friends, this mailingin list is also very helpful but search those 2 places before you ask. I am assuming that