1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
<?php
echo "<select name='listlabo' id='Nomlab' '>";
echo "<option value='-1'>Choose a Lab</option>";
//echo "<select name='labo'>";
mysql_connect("localhost","root","");
mysql_select_db("projet");
$sql = "SELECT distinct(Nomlab) FROM laboratoire ORDER BY Nomlab";
$sql2 = "SELECT id_labo FROM laboratoire";
$res = mysql_query($sql);
$res2 = mysql_query($sql2);
while($row = mysql_fetch_assoc($res) && $row2 = mysql_fetch_assoc($res2)){
echo "<option value='".$row["Nomlab"]."'>".$row["Nomlab"]."</option>";
echo "</select>";
echo "<p><b>Identifiant du labo à saisir après ! : '".$row2["id_labo"]."'<b><p>";
}
echo "</select>";
?> |