1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| $sql = "UPDATE gr_adherents_test SET
adherentCivilite = '$adherentCivilite',
adherentNom = '$adherentNom',
adherentPrenom = '$adherentPrenom',
adherentLicence = '$adherentLicence',
adherentDateNaissance ='$datenaisanceeng',
adherentAdresse = '$adherentAdresse',
adherentVille = '$adherentVille',
adherentCodePostal = '$adherentCodePostal',
adherentTelephone = '$adherentTelephone',
adherentPortable = '$adherentPortable',
adherentEmail ='$adherentEmail',
";
$sql .= "adherentDateDemande1 = ".(( !empty($_POST['datedemande1']) )? "'".$_POST['datedemande1']."'" : "NULL").",";
$sql .= "adherentDateDemande2 = ".(( !empty($_POST['datedemande2']) )? "'".$_POST['datedemande2']."'" : "NULL").",";
$sql .= "adherentDateDemande3 = ".(( !empty($_POST['datedemande3']) )? "'".$_POST['datedemande3']."'" : "NULL").",";
$sql .= "adherentDateAdhesion = '$adherentDateAdhesion,
adherentNotes = '$adherentNotes',
adherentFlag = '$adherentFlag'
WHERE adherentId = '$adherentId'"; |
Partager