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:

----- Original Message -----
From: "Leif K-Brooks" <[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 (
> To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to