Voila j'ai créé ma page de demande d'intervention :
<?php
$date = date("d-m-Y");
$heure = date("H:i");
$sql = "SELECT
I.num_interv, I.date_demande, I.heure_demande, I.description, I.num_user,US.login_user, US.pass_user, S.num_service, S.nom_service,
I.num_service, I.num_urg, U.num_urg, U.nom_urg, US.num_user, US.nom_user, US.prenom_user, I.num_tech, T.num_tech, T.nom_tech, T.prenom_tech
FROM intervention I, urgence U, users US, technicien T, service S
WHERE U.num_urg = I.num_urg
AND I.num_user = US.num_user
AND I.num_tech = T.num_tech
AND S.num_service = I.num_service";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());
while ($Tab = mysql_fetch_array($sql_exe))
{
?>
<br>
<form action="envoi_demande.php" method="post">
<table>
<tr>
<td width="220"><span class="intitule_lig">Demandeur : </span></td>
<td> <input name="demandeur" type="text" size="31" readonly="enable" value="<?php echo $_SESSION['login'] ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Date de la demande : </span></td>
<td> <input name="date" type="text" size="31" readonly="enable" value="<?php print_r($date) ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Heure de la demande : </span></td>
<td> <input name="heure" type="text" size="31" readonly="enable" value="<?php print_r($heure) ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="220"><span class="intitule_lig">Service : </span></td>
<td> <input name="service" type="text" size="31" readonly="enable" value="<?php echo $Tab["nom_service"] ?>"></td>
</tr>
</table>
<table>
<tr>
<td width="216"><span class="intitule_lig">Urgence : </span></td>
<?
$sql = "Select * From urgence order by nom_urg";
$sql_exe = mysql_query($sql) or die('Erreur : ' . mysql_error());
?>
<td>
<?
$ld = "<SELECT NAME='urgence'>";
$ld .= "<OPTION VALUE=0>Choisir niveau de l'urgence</OPTION>";
while ( $row = mysql_fetch_array( $sql_exe)) {
$numurg = $row["num_urg"];
$nomurg = $row["nom_urg"];
$ld .= "<OPTION VALUE='$numurg'>$nomurg</OPTION>";
}
$ld .= "</SELECT>";
echo $ld
?>
</td>
</tr>
</table>
<table>
<tr>
<td><span class="intitule_lig">Description de la demande : </span></td>
</tr>
</table>
<table>
<tr>
<td><textarea name="descrip" cols="80" rows="10"></textarea></td>
</tr>
</table>
<br>
<table width="650" border="0" cellpadding="0">
<tr>
<td align="right"><input name="envoi" type="submit" value="Envoyer" /></td>
<td align="left"><input name="reset" type="reset" value="Annuler" /></td>
</tr>
</table>
</form>
<?php } ?>A savoir que le nom du demandeur de l'interv je le récupère grace à mes variables de session.
Merci
