Re: Polls?
| From: | Leif K-Brooks | Date: | Fri, 08 Nov 2002 07:39:33 +0000 |
| Subject: | Re: Polls? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23127@lists.php.net to get a copy of this message | ||
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: [PHP-DB] Polls?-- 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.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. Anyunauthorized 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