Thanks, but my problem is how to efficiently display a page with all of the polls with results. Also, I need a variable number of questions, which that tutorial doesn't provide. Thanks, though. Ignatius Reilly wrote: >One possibility: > >table questions( questionID, question_text, ...) PRIMARY KEY( questionID) > >table answers( FK_questionID, individualID, answer_code, ...) PRIMARY KEY( >FK_questionID, individualID) > >For very simple online polls, there is a nice tutorial in Devshed: >http://www.devshed.com/Server_Side/PHP/PHPDemocracy > >HTH >Ignatius >____________________________________________ >----- Original Message ----- >From: "Leif K-Brooks" <eurleif@buyer-brokerage.com> >To: <php-db@lists.php.net> >Sent: Friday, November 08, 2002 8:15 AM >Subject: Polls? > > > > >>I'm working on a polling system, and I'm having a bit of a problem. I'm >>not sure how to store the questions. Storing them in a seperate table >>would require a query for each poll displayed - not good. I've also >>thought of storing them as a serialized array. Any thoughts on this? >> >>-- >>The above message is encrypted with double rot13 encoding. Any >> >> >unauthorized attempt to decrypt it will be prosecuted to the full extent of >the law. > > >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> >> > > > > -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
