Php liste deroulente a partir d'une table

<?php
//connexion base
mysql_connect("host","login","password");
mysql_select_db("nom_base");
//lecture table
$query="SELECT * FROM specialite";
$result=mysql_query($query) or die ("pb requette ".mysql_error());
mysql_close();
//generation liste
echo '<select name="specialite">';
while ($ligne=mysql_fetch_array($result)){
	echo '<option value="'.$ligne['num_specialite'].'">'.$ligne['libelle_specialite'].'</option>';
}
echo '</select>';
?>

<?php
//connexion base
mysql_connect("localhost", "root", "");
mysql_select_db("item");
 
//lecture table
$query="SELECT * FROM specialite";
$result=mysql_query($query) or die ("pb requette ".mysql_error());
mysql_close();
//generation liste
echo "<form action=\"kkk.php\" method=\"post\" enctype=\"multipart/form-data\" name=\"form1\">"; 

echo '<select name="specialite">';
while ($ligne=mysql_fetch_array($result)){
echo '<option value="'.$ligne['NUM_SPEC'].'">'.$ligne['LIBEL_SPEC'].'</option>';
}
echo '</select>';
echo " <input type=\"submit\" name=\"Submit\" value=\"VALIDER\">  "; 
echo '</form>';
  
?>	
			

<?php
	$kog=$_POST['specialite'] ;
	
	echo $kog ;
	
	
	?>