[Resolved] Automatic form

[_boriz]

I want to make a number of radiobuttons, depending on the number in a database.

Ive got a database with questions, where every question have between 2-5 answers, and the number of answers is set by a number.

How do i write the code that depending on that number creates that many radiobuttons.

thanks
//_boriz

[ZibingsCoder]

Read up a bit.

[jkurrle]

A FOR loop is probably the way to go, but you also could probably use a WHILE loop. Here's an example of some pseudo code that illustrates what I mean...

//assuming you already have a connection to your database...
$select="select * from Answers
   where Question_Number='$Question_Number'";
$result=mysql_query($select)
   or die("Select from Answers table had errors");
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
   {
   extract($row);
   echo "<input type='radio' name='$Question_Number' 
      Value='$Answer_Value'>$Answer_Data<br/>";
   }

Then, you don't need to keep track of how many answers you have for the question. The database serves up all the answers for that question, based on the search criteria.