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
| $query= "SELECT CLIENT_ID, FK_LOCALITE, CLIENT_NO, CLIENT_NOM, CLIENT_PRENOM, CLIENT_RUE, CLIENT_TEL_FIXE, CLIENT_TEL_MOBILE, CLIENT_EMAIL FROM client, localite WHERE FK_LOCALITE=LOCALITE_ID and CLIENT_ID = '$numclimod'";
$result = mysql_query ($query);
$value = mysql_fetch_array ($result);
?>
</div>
<form method=post action=clientmenu.php?modifierclient=<?php echo $value ["CLIENT_ID"]; ?>>
<table width="502" border="1" align="center">
<tr>
<th width="21" height="23"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Id</font></th>
<td><?php echo $value["CLIENT_ID"]; ?> </td>
</tr>
<tr>
<th width="155"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Localite</font></th>
<td> <select size="1" name=localite>
<?php
$requete = "SELECT LOCALITE_ID, LOCALITE_NOM, LOCALITE_NPA FROM localite, client";
$resultat = mysql_query($requete);
while ($valeur=mysql_fetch_array($resultat))
{
echo "<option value =".$valeur ["LOCALITE_ID"]."if (FK_LOCALITE == LOCALITE_ID) echo 'selected'>".$valeur["LOCALITE_NOM"]."</option>\n";
}
//etant donnée que j'ai déjà un tableau en dessus il faut changer les noms des variables
?>
</select></td> |
Partager