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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 8:15 AM Subject: [PHP-DB] 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
