rendered paste body<?php $cnx = mysql_connect("localhost","root","") or die( "Connexion impossible."); $db = mysql_select_db("ProjetBdd") or die( "Accès base impossible.");// Requête SQL $sql = "SELECT noasso from asso"; $requete = mysql_query( $sql, $cnx)or die( "Exécution requête impossible."); mysql_close( $cnx);// Construction de la chaîne de caractères qui fait la // liste$ld = "<SELECT NAME='lstDep'>";$ld .= "<OPTION VALUE=0>Choisissez</OPTION>";// On boucle sur la tablewhile ( $row = mysql_fetch_array( $requete)) { $noasso = $row["noasso"]; //$nomasso = $row["nomasso"];$ld .= "<OPTION VALUE='$noasso'>$noasso</OPTION>";}$ld .= "</SELECT>";?><html> <head> <title>insertion de donnee personne</title> </head><body><form name="insertion" action="Einsertion2.php" method="POST"> <table border="0" align="center" cellspacing="2" cellpadding="2"> <tr align="center"> <td>nom</td> <td><input type="text" name="nom"></td> </tr> <tr align="center"> <td>age</td> <td><input type="text" name="age"></td> </tr> <tr align="center"> <td>sexe</td> <td> <input type="radio" name="sexe" value="M"> Masculin <input type="radio" name="sexe" value="F"> Feminin </td> <tr align="center"> <td>noasso</td> <td><?php print $ld;?></td> </tr> <tr align="center"> <td colspan="2"><input type="submit" value="inserer"></td> </tr> </table></form></body></html>