drop down menu empty

[jakebrand]

I have a drop down menu that I am populating from a field in a mysql database. The script is putting it in the drop down but they are not listed, I can check on a spot where one should be and summit it and i get the right item when I run it through the next script.
please help

[Anon]

Are you putting any text after the <option> tag?

example:

<select name="whatever">
<option value="Dog">Dog</option>
</select>

[jakebrand]

here is the code that i am trying now i have looked in i dont know how many books and what not
$query = \"select room from info\";
$result = mysql_query($query);

while ($row = mysql_fetch_row($result))
{
printf(\"<option value=\\"%s\\">%s\", $row[0], $row[1]);
}

[Anon]

while ($row = mysql_fetch_row($result))
{
printf(\"<option value=\\"%s\\">%s\", $row[0], $row[1]);
}

someone may likely give a better explanation, but for me, I don't like the C/C++ way of printing to screen. I prefer echo, but am sure you have your prefs.

anyway, while printf and %s probably require them, there seem to be an awful lot of backslashes - why on the $query?

this works well for me

while ($row = mysql_fetch_row($result))
{
echo("<option value=\"$value\">$row[0], $row[1]">;
}