Re: [PHP-DB] Polls?

[Leif K-Brooks]

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" <[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

--
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.