Code : Tout sélectionner
$req0=$db->prepare('SELECT * FROM info_adherents WHERE id = '.$num_adherent.'');
$req0->execute();
$data=$req0->fetch();
$mail = $data['mail_adherent'];
$req3 = $bdd->prepare("INSERT INTO clients_particuliers (nom_client, adresse_client, commune_client, CP_client, tel_client, mail_client, id_adherent) VALUES (:nom_client, :adresse_client, :commune_client, :CP_client, :tel_client, '$mail', '.$num_adherent.') ");