Use the dual table questions and answers suggestion before.

Then just use a loop:

$question = mysql_query("select * from questions where id={$this_question}");
while ($r = mysql_fetch_array($question)) {
   $answers = mysql_query("select * from answers where qid={$r[id]}");
   while ($s = mysql_fetch_array($answers)) {
       print "<question input and labels>";
   }
}

On Fri, 8 Nov 2002, Leif K-Brooks wrote:

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

---------------------------------------------------------------------------
Peter Beckman            Systems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED]                             http://www.purplecow.com/
---------------------------------------------------------------------------


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to