Populate a Combobox with Sql data?

[Ayeka]

Is there a way to populate the combobox control with data from my SQL server, instead of trying to hard code <option>'s?

Thank you.

[Spaceman-Spiff]

of course, its just like retreiving data from database into html
just print the options on loop
example:

Code Select Expand

echo '<select name="people">';
$request = mysql_query("SELECT * FROM members");
while ($member = mysql_fetch_assoc($request))
{
   echo '<option value="' . $member['member_id'] . '">' . $member['name'] . '</option>';
}
echo '</select>';