";
while($row = mysql_fetch_row($result))
{
$affid=$row[0];
$affnom=$row[1];
$affprenom=$row[2];
$affemail=$row[3];
$affgenre=$row[4];
echo "
| $affid |
$affgenre |
$affnom |
$affprenom |
$affemail |
";
}
echo "";
/********** MODIFICATION **********/
$query = "UPDATE $table SET prenom=\"$prenom\", nom=\"$nom\", email=\"$email\", genre=\"$genre\" WHERE id = \"$identifiant\"";
$result = mysql_query($query);
/********** pour visualiser l'enreg après la modifocation **********/
$query = "SELECT * FROM $table WHERE id = $identifiant";
$result = mysql_query($query);
echo "enregistrement après modification !";
echo "";
while($row = mysql_fetch_row($result))
{
$affid=$row[0];
$affnom=$row[1];
$affprenom=$row[2];
$affemail=$row[3];
$affgenre=$row[4];
echo "
| $affid |
$affgenre |
$affnom |
$affprenom |
$affemail |
";
}
echo "
";
// on ferme la base
mysql_close();
?>