title: Populate DropDown and Get Selected Value From Database
body: <p>I have the code to select the values from a database for populating my drop down list. But my question is if I stored the value of what the user selected in another database, how would I go about pulling that back out and making that the selected choice.</p>
  
  <pre><code>&lt;select name="dropdown1" id="dropdown1"&gt;
  
  &lt;?php
  for ($i = 0; $i &lt; 5; $i++)
  {
      print '&lt;option id="'.$options[$i]["ID"].'" value="'.$options[$i]["Value"].'"&gt;'.$options[$i]["Name"].'&lt;/option&gt;'."\n";
  }
  ?&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>So the users stored value is lets say red. How would I make red the selected value as it populates my drop down list?</p>
  
  <p>Thanks e</p>