Pull down menus..

[Anon]

I know how to make pull down menus populated with references from the mysql database.. however what I am having trouble with is having the saved data as the selected option in the pull down menu..

This is the code I have:

<p>&lt;?php<br>
<br>
// &lt;---print the referee list in a pull down menu<br>
<br>
$result = mysql_query(&quot;SELECT * FROM referees ORDER BY refname
ASC&quot;,$db);<br>
<br>
while ($myrow = mysql_fetch_array($result)) {<br>
<br>
if (eregi($mp_referee, $chosenref)) {<br>
<br>
printf(&quot;&lt;option selected value=\&quot;%s\&quot;&gt;%s,
%s&lt;/option&gt;\n&quot;, $myrow[&quot;refname&quot;],
$myrow[&quot;refname&quot;], $myrow[&quot;refcity&quot;]);<br>
<br>
} else {<br>
<br>
printf(&quot;&lt;option value=\&quot;%s\&quot;&gt;%s, %s&lt;/option&gt;\n&quot;,
$myrow[&quot;refname&quot;], $myrow[&quot;refname&quot;],
$myrow[&quot;refcity&quot;]);<br>
<br>
}<br>
<br>
}<br>
<br>
?&gt;</p>

PLEASE tell me what I am doing wrong 🙂