UPDATE champs date

   $sql = "UPDATE mr_miserelations
          SET  heurerdv = '$heurerdv';
              daterdv = '$daterdv'        
              WHERE miserelation_id = '$miserelation_id'" ;

CREATE TABLE mr_miserelations (miserelation_id INT (4) not null AUTO_INCREMENT, 
PRIMARY KEY (miserelation_id), 
INDEX (miserelation_id), 
UNIQUE (miserelation_id) ,
intervenant_id INT (3) not null , 
client_id INT (6) not null , 
daterdv varchar(10),
heurerdv varchar(5),
date_creation timestamp not null);