Organizing Database Survey Results

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
URWhatUXpress
Forum Newbie
Posts: 11
Joined: Sat Aug 30, 2003 5:00 pm
Location: Grand Rapids, MI

Organizing Database Survey Results

Post 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 }
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post 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
User avatar
URWhatUXpress
Forum Newbie
Posts: 11
Joined: Sat Aug 30, 2003 5:00 pm
Location: Grand Rapids, MI

Post 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 }
Post Reply