php survey

Hello everyone

I have just completed a survey that posts data to a mysql db using php in
dreamweaver
Now I want to create a results page that shows sums of all the answers posted
in each field...
Any details how I can put a sum of "FieldA where the answer =Y" or something
like that?
I have about 40 fields on one page so creating a recordset for each one would
be kinda big I would think... any suggestions?

Thanks millions!

"TommyG" <webforumsuser (AT) macromedia (DOT) com> wrote

Hello everyone

I have just completed a survey that posts data to a mysql db using php in
dreamweaver
Now I want to create a results page that shows sums of all the answers
posted
in each field...
Any details how I can put a sum of "FieldA where the answer =Y" or
something
like that?
I have about 40 fields on one page so creating a recordset for each one
would
be kinda big I would think... any suggestions?

Thanks millions!

Take a look at COUNT() in the MySQL docs.

HTH

-Rb