Passing an array into an select/option

[Anon]

Hello all.

I am trying to pass data from an sql query into a select/option box (html) for users to be able to choose categories. Any general help or direction would be great!

Thanks, Craig

[Anon]

echo "<select name='whatever'>";
$result = mysql_query("select * from table");
while ($row = mysql_fetch_array($result)) {
$value = $row["field_name"];
echo "<option value='$value'>$value</option>";
}
echo "</select>";

[cornelalexa]

function build_ugroups($id)
{
$_db = new db;//it's a wrapper that i wrote

$db->query("select * from user_group");
$ret="<option value=0> Select a group</option>";
while($db->move_next())
{
if($id==$db->get_field('user_group_id'))
{
$ret.="<option selected value=".$db->get_field('user_group_id').">".$db->get_field('name')."</option>";
}
else
{
$ret.="<option value=".$db->get_field('user_group_id').">".$_db->get_field('name')."</option>";
}
}

return $ret;
}