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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
