Dreamweaver - php survey

Author

php survey

TommyG

2004-08-05, 7:15 pm

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!

-Rb

2004-08-06, 12:15 pm

"TommyG" <webforumsuser@macromedia.com> wrote in message
news:cetqjl$5r0$1@forums.macromedia.com...
> 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