MySQL data to an HTML "<SELECT......" field

[nogeekyet]

I am trying to move MySQL data to an HTML "<SELECT......" field. Inserting code such as <?php echo htmlspecialchars($row["S_NameLast"]); ?> into the value of an "<input...." field works fine. As I said, I can't get it working for a "select" field.

[cahva]

A little example:

<select name="sel">
<?php
$sql = "SELECT S_NameLast FROM table";
$result = mysql_query($sql);
while ($r = mysql_fetch_assoc($result)) {
    echo '<option value="'.$r['S_NameLast'].'">'.$r['S_NameLast'].'</option>';
}
?>
</select>

[nogeekyet]

I applied the code to my work and it WORKS!

Thanks a lot!

[bradgrafelman]

Don't forget to mark this thread resolved.