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
|
<?
//Récupération de la liste des demandes dans la table T_DI
$req_di = mysql_query ("SELECT * FROM t_di order by no_di DESC limit $nb_limit");
$nb_di = mysql_numrows($req_di);
//Données de chaque demande
for ($i=0;$i<$nb_di;$i++)
{
$no_di = mysql_result($req_di,$i,"no_di");
$date_di = mysql_result($req_di,$i,"date_di");
$etat_di = mysql_result($req_di,$i,"etat_di");
$no_prior = mysql_result($req_di,$i,"no_prior");
$mat_app = mysql_result($req_di,$i,"mat_app");
$req_app = mysql_query ("SELECT * FROM t_util WHERE mat_util='$mat_app'");
$donnees = mysql_fetch_array ($req_app);
$pren_app = $donnees['pren_util'];
$nom_app = $donnees['nom_util'];
$no_serv = mysql_result($req_di,$i,"no_serv");
$req_nom_serv = mysql_query ("SELECT * FROM t_serv WHERE no_serv = '$no_serv'");
$donnees = mysql_fetch_array ($req_nom_serv);
$nom_serv = $donnees['nom_serv'];
$descrip_di = mysql_result($req_di,$i,"descrip_di");
?>
<!Affichage des DONNEES>
<!*********************>
<tr><td align="right"><b><? echo $no_di ?></b></td><td align="center"><? echo $date_di ?><td align="center"><? echo $etat_di ?></td><td align="center"><font color = "<? echo $color_prior[$no_prior]; ?>"><b><? echo $no_prior ?></b></font></td><td align="center"><? echo "$nom_app" ?><td align="center"><? echo $nom_serv ?></td><td><? echo $descrip_di ?></td>
<td><a href="consult_DI.php?no_di=<? echo $no_di ?>">Détail</a> |
Partager