[thelist] Query selected

Andrew andrew at humanbehaviour.co.uk
Tue Mar 4 07:25:01 CST 2003

Can anyone tell me why this 'selected' isn't working?  It does keep a fixed id
selected but not the one that was selected and aslo doesn't return any results?

echo "<select name=\"CityID\" size=\"1\" class='menuForm'>";

$result=mysql_query("SELECT City, CityID FROM city ORDER BY City");
while ($row = mysql_fetch_array($result))

echo "<option value=\"$city_id\" selected> $city </option>";
echo "</select>";


More information about the thelist mailing list