Populate DropDown and Get Selected Value From Database
<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>
