1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
$connexion=mysql_connect('localhost', 'root') or die ("connextion au serveur impossible");
$db=mysql_select_db('defi', $connexion) or die ("sélection de la base impossible");
$req="SELECT * FROM identification ORDER BY nom DESC";
$res=mysql_query($req);
$liste = array (); // tableau de lignes
while($ligne=mysql_fetch_object($res))
{array_push ($liste, array ('id' => $ligne->id, 'nom' => $ligne->nom, 'prenom' => $ligne->prenom)) ;}
echo "<FORM action=\"script.php\" method=\"POST\">
<SELECT name=\"nom\">";
foreach($liste as $val)
{
echo "<OPTION value=\"" . $val['id'] . "\">" . $val['nom'] . " " . $val['prenom'] . "</option>\n";
}
echo "</SELECT></FORM>"; |
Partager