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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| <?php
$query = "SELECT USER_ID, Nom, Num_SIM, Num_ligne FROM select_nom_prenom_user ORDER BY Nom, Num_SIM, Num_ligne ASC ";
if($result = mysqli_query($link, $query));
{
echo'<select name="select_nom_prenom_user">';
echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Nom</option>';
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Nom = $idresult[1];
echo'<option value="' . $USER_ID . '">' . $Nom . '</option>';
}
echo'</select></p><p>';
}
$query = "SELECT USER_ID, Num_ligne, Nom, Num_SIM FROM select_nom_prenom_user ORDER BY Nom, Num_SIM, Num_ligne ASC";
if($result = mysqli_query($link, $query));
{
echo'<select name="select_nom_prenom_user">';
echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Num ligne</option>';
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Num_ligne = $idresult[1];
echo'<option value="' . $USER_ID . '">' . $Num_ligne . '</option>';
}
echo'</select></p><p>';
}
$query = "SELECT USER_ID, Num_SIM, Nom, Num_ligne FROM select_nom_prenom_user ORDER BY Nom, Num_SIM, Num_ligne ASC";
if($result = mysqli_query($link, $query));
{
echo'<select name="select_nom_prenom_user">';
echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Num SIM</option>';
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Num_SIM = $idresult[1];
echo'<option value="' . $USER_ID . '">' . $Num_SIM . '</option>';
}
echo'</select></p><p>';
}
$query = 'SELECT USER_ID, Operateur FROM abonnements where USER_ID="ANSTETT"' ;
echo $query;
$result = mysqli_query($link, $query);
echo $result;
echo $query;
if($result = mysqli_query($link, $query));
{
echo $result;
while ($idresult = mysqli_fetch_row($result))
{
$USER_ID = $idresult[0];
$Operateur = $idresult[1];
echo $Operateur;
}
} |
Partager