loading surnames from database to drop box

[brockie99]

I am trying to get clients surnames from their records in the database to appear in a drop down box for selection on my web page. This feature is currently meant to load when the page is loaded, but doesn't seem to work. Here is the code i have written for it:
Select Member by Surname:
<select name = "memselect">
<?php

if ($memselect)

{

$select = mysql_query("SELECT surname,id FROM members",$db);

while($myrow = mysql_fetch_array($select))

{

echo "<option value=\"".$myrow['id']."\">".$myrow['surname']."</option>";

}
echo mysql_error();
}

?>

</select>

Any help would be much appreciated.

[redrabbit]

Well my code works fine:

<select>
$result = mysql_query("SELECT id, name from members", $link);

While ($row = mysql_fetch_array($result)) {
echo "<option value='";
echo $name;
echo "'>";
echo $name;
}

</select>

So everytime it looks it would create this:
<option value="name"> Name
<option value="name"> Name
... until the end.

Hope this helps.