Re: Polls?
| From: | Ignatius Reilly | Date: | Fri, 08 Nov 2002 07:32:37 +0000 |
| Subject: | Re: Polls? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23126@lists.php.net to get a copy of this message | ||
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?
> 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
>
>