[RESOLVED] Populating a list/menu from MySQL

[gszauer]

Hi,
is there a way to populate a list, or a menu form using php, and MySQL?
Basically i have a list, and i am planing to import 2 variables,
id, and name, bouth id and name are variables loaded from MySQL (yes there are multiple id's, and name's)
Name would be the label displayed, and the value would be id. Thats what i need.
After that i will make a submit button, witch will post the selected id to a different file.
How can i achive this? Does anyone hae any samples maybe?
I appriciate all help, and thank you for your time.
~Gabor

[devinemke]

$result = mysql_query('SELECT id, name FROM table') or exit(mysql_error());
echo '<select name="list">';
while ($row = mysql_fetch_assoc($result))
{
	echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
}
echo '</select>';