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 t

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 = 'fem

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 small

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 f

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 y