Organizing Database Survey Results
Posted: Tue Nov 25, 2003 9:53 am
Hello there,
I am having a bit of trouble determining what the logic should be for getting adverages of survey scores people have entered into the database via a form. It was easy enough to list survey reponses person by person, but I am not sure how to take the numbers from the database (all answers are 1 through 5), then figure out what the adverage rating is for one specific question.
I was thinking mysql_num_rows() to get the total row count from a query, but I am a bit stumped on the rest of the logic. I would love any help anyone can give. I'll be here until 11:45 EST, and again at 2:30 EST.'
Thank you in advance. Let me know if I can calrify anything.
{ d }
I am having a bit of trouble determining what the logic should be for getting adverages of survey scores people have entered into the database via a form. It was easy enough to list survey reponses person by person, but I am not sure how to take the numbers from the database (all answers are 1 through 5), then figure out what the adverage rating is for one specific question.
I was thinking mysql_num_rows() to get the total row count from a query, but I am a bit stumped on the rest of the logic. I would love any help anyone can give. I'll be here until 11:45 EST, and again at 2:30 EST.'
Thank you in advance. Let me know if I can calrify anything.
{ d }