Drop-down menu van MySQL data

<?


$Link = mysql_connect("myserv","username","password");
$Query = "Select name from mytable";
$DBName = "addresslist";
$results = mysql_db_query($DBName, $Query, $Link);


?>
Select a name
<select name = "drop1" size="1">
<Option Value=" ">Select One:</option>
<? //Begins PHP

for($u=0;$u<mysql_num_rows($results); $u++) {
$ID=mysql_result($results,$u,'name');
?>

<option value="<? echo($ID); ?>"><? echo($ID); ?></option><? //Begins PHP
<? //Begins PHP
}
?>
</select>

<? //Begins PHP
if (mysql_db_query ($DBName, $Query, $Link)) {

}

else {
print ("FAILURE<BR>\n");
}

mysql_close ($Link);

?>

<?
 
 
$Link = mysql_connect("myserv","username","password");
$Query = "Select name from mytable";
$DBName = "addresslist";
$results = mysql_db_query($DBName, $Query, $Link);
 
 
?>
Select a name
<select name = "drop1" size="1">
<Option Value=" ">Select One:</option>
<? //Begins PHP
 
for($u=0;$u<mysql_num_rows($results); $u++) {
$ID=mysql_result($results,$u,'name');
?>
 
<option value="<? echo($ID); ?>"><? echo($ID); ?></option><? //Begins PHP
<? //Begins PHP
}
?>
</select>
 
<? //Begins PHP
if (mysql_db_query ($DBName, $Query, $Link)) {
 
}
 
else {
print ("FAILURE<BR>\n");
}
 
mysql_close ($Link);
 
?>

<?php
$Query = "Select DISTINCT('name') from mytable";
?>

<?php
$Query = "Select DISTINCT('name') from mytable";
?>