Page 1 of 1

Organizing Database Survey Results

Posted: Tue Nov 25, 2003 9:53 am
by URWhatUXpress
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 }

Posted: Tue Nov 25, 2003 10:24 am
by infolock
this may be of use ( is how i learned ). page 2 in particular, but page 1 is good too...

edit : oops, wrong link :oops:

try this one instead:

http://www.onlamp.com/pub/a/onlamp/exce ... ndex1.html

Posted: Tue Nov 25, 2003 10:33 am
by URWhatUXpress
Thanks, it looks like this article will help a lot.

If anyone else has any ideas, though, feel free to pass them along.

Back to work.

{ d }