title: Using PHP and MySQL to populate Quiz web application Form
body: <p>Here is the database-design <a href="http://www.flickr.com/photos/michaelstitt/6077647604/in/photostream/" rel="nofollow noreferrer">http://www.flickr.com/photos/michaelstitt/6077647604/in/photostream/</a> that I decided upon -- using <a href="https://stackoverflow.com/questions/7102521/database-design-for-developing-quiz-web-application-using-php-and-mysql">the help from my previous post on Stack Overflow</a>.</p>
  
  <p>I am attempting to build a Quiz web application using PHP and MySQL.  It seems a lot easier to build an HTML form and code the 'question' and 'question_choices' by hand.  However, I'd like to populate the form using data in my database. </p>
  
  <p>So, my question is <strong>how do you suggest I pull data from the tables 'question' or 'question_choices' from my database to fill in HTML forms?</strong></p>
  
  <p>The HTML forms will look something like this:</p>
  
  <pre><code>&lt;form method="post" action="quiz1.php"&gt;
  
      &lt;b&gt;What was the make/model of my first car?&lt;/b&gt;
      &lt;br&gt;
      &lt;input type="radio" value="0" name="q_1"&gt;
      Toyota Camry &lt;br /&gt;
      &lt;input type="radio" value="1" name="q_1"&gt;
      Honda Accord &lt;br /&gt;
      &lt;input type="radio" value="0" name="q_1"&gt;
      Ford Explorer &lt;br /&gt;
      &lt;input type="radio" value="0" name="q_1"&gt;
      Plymouth Voyager &lt;br /&gt;
  </code></pre>
  
  <p>Honda Accord will be derived from the 'choice' column in the table question_choices.  The value="1" will be determined by the 'is_right_choice' column and will populate the 'is_right' column in the user_question_answer table.  <strong>Does this seem like a good idea?</strong></p>
  
  <p>Any other advice would be greatly appreciated.  Thank you in advance.</p>