database design in a survey/poll system

From: Date: Wed, 17 Nov 2010 13:42:08 +0000
Subject: database design in a survey/poll system
Groups: php.general 
Request: Send a blank email to php-general+get-309537@lists.php.net to get a copy of this message
I plan to design a small survey/poll system similar to polldaddy<http://polldaddy.com/> . And I have some confusion in designing the database for the multiple/single choice questions. Of course, it is possible to use one table to store the question title and another table to store the choice item(one record for each choice item). My main concern is that whether we can place the choices together in the same table(and in one ) with the question title. I guess it can be faster to read from one table than reading from two table. And my idea is to use a delimiter to separate the choices. And the handling of the choices are done in the php script. But what delimiter should be used? Can anyone help? Thanks!

« previous php.general (#309537) next »