Placing query result in html dropdown box

[blackmercury]

<?
$db = mysql_connect("localhost", "user", "passwd");

mysql_select_db("database",$db);

$sql="select os from os'";

$result=MySQL_query($sql,$db);
while($myrow=MySQL_fetch_array($result))
{
$name=$myrow["$tem"];
$name0=$myrow[0];
$name1=$myrow[1];
$name2=$myrow[2];
$name3=$myrow[3];
$name4=$myrow[4];
$name5=$myrow[5];
$name6=$myrow[6];
$name7=$myrow[7];
$name8=$myrow[8];
$name9=$myrow[9];
$name10=$myrow[10];
$name11=$myrow[11];
$name12=$myrow[12];
$name13=$myrow[13];
}
?>

When it echos "$name2" it shows all of data likes
"linux 2.1red hat 8.0united linux 1.0". I am wanting to put the individual os in an html drop down box, like this. how do i seperate them to do so? thanks

<SELECT NAME="os"SIZE="1">
<option value="linux 2.1">linux 2.1
<option value="red hat 8.0">red hat 8.0
<option value="united linx 1.0">united linux 1.0
<option value=" " selected>
</SELECT>😕

[non_zero]

The while() control loops through each entry, so you don't have to define each OS inside of it. The field "os" will be returned as a hash in $myrow ($myrow[os]).

<?
$db = mysql_connect("localhost", "user", "passwd");

mysql_select_db("database",$db);

$sql="select os from os'";

echo "<select>"
$result = mysql_query($sql,$db);
while($myrow=mysql_fetch_array($result)) {
echo "<option>$myrow[os]</option";
}
echo "</select>";
?>