displaying drop down menus

[fife]

Hi I was just wondering if someone could send me a good tutorial on pulling several fields from a table and displaying them all in one drop down menu for people to select one of them.  I dont know what this is called to I dont know what to research online.

[Pikachu2000]

Is this what you're talking about?

 

$query = "SELECT `id`, `name` FROM `table`";
$result = mysql_query($query);
echo "<select name=\"select_field\">\n";
while( $array = mysql_fetch_assoc($result) ) {
     echo "<option value=\"{$array['id']}\">{$array['name']}</option>\n";
}
echo "</select>\n";