1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
$query1 = "SELECT VM, VM FROM client ORDER BY 'VM' ASC";
$query2 = "SELECT date_format(periodepaie,\"%Y-%m\")FROM periodepaie";
$query3 = "SELECT Traitement, Traitement FROM traitement ORDER BY 'Traitement' ASC";
$result1 = mysql_query($query1) or die ("Requête echouée");
$result2 = mysql_query($query2) or die ("Requête2 echouée");
$result3 = mysql_query($query3) or die ("Requête3 echouée");
/* Affiche les résultats dans menu déroulant */
/*----------MENU 1*/
echo '<div id="machine"><label for="VM"><dfn>Machine VM</dfn></label> <select name="VM"></div><br>';
while($liste=mysql_fetch_row($result1))
{
echo '<option selected value="',$liste[1],'">',$liste[0],'</option>';
}
echo '</select>';
/*---------MENU 2*/
echo '<div id="periodepaie"><label for="periodepaie"><dfn>Periode de paie</dfn></label> <select name="periodepaie"></div><br>';
while($liste=mysql_fetch_row($result2))
{
echo '<option value="',$liste[1],'">',$liste[0],'</option>';
}
echo '</select>';
/*---------MENU 3*/
echo '<div id="traitement"><label for="traitement"><dfn>Traitement</dfn></label> <select name="traitement"></div><br>';
while($liste=mysql_fetch_row($result3))
{
echo '<option value="',$liste[1],'">',$liste[0],'</option>';
}
echo '</select>'; |
Partager