Bonjour, voila le code source:
<?php
include('connexion.php');
if(isset($_POST['id_client']) && isset($_POST['num_matricule_fiscale']) && isset($_POST['pays'])&& isset($_POST['ville'])&& isset($_POST['code_postal'])&& isset($_POST['regime_fiscale'])&& isset($_POST['id_compte'])&&isset($_POST['e_mail'])&& isset($_POST['mot_passe'])&& isset($_POST['nom']) && isset($_POST['num_tel'])&& isset($_POST['num_portable'])&& isset($_POST['adresse']))
{
$id_client="";
$num_matricule_fiscale= $_POST['num_matricule_fiscale'];
$comp_adresse=$_POST['comp_adresse'];
$pays=$_POST['pays'];
$ville=$_POST['ville'];
$code_postal=$_POST['code_postal'];
$regime_fiscale=$_POST['regime_fiscale'];
$id_compte="";
$e_mail=$_POST['e_mail'];
$mot_passe=$_POST['mot_passe'];
$nom= $_POST['nom'];
$num_tel=$_POST['num_tel'];
$num_portable=$_POST['num_portable'];
$adresse=$_POST['adresse'];
//Requète SQL
$requete="INSERT INTO client VALUES('$id_client','$num_matricule_fiscale','$comp_adresse','$pays','$ville','$code_postal','$regime_fiscale')";
$result=mysql_query($requete);
$id_client=mysql_insert_id();
$requete1="INSERT INTO compte VALUES ('$id_compte','$e_mail','$mot_passe' )";
$result1=mysql_query($requete1);
$id_compte=mysql_insert_id();
$requete2="INSERT INTO personne VALUES ('$nom', '$num_tel', '$num_portable', '$adresse')";
$result2=mysql_query($requete2);
if (!$result)
{
echo 'Requete invalide : ' . mysql_error;
}
}
mysql_close();
?>
j'espère que quelqu'un peut trouver l'erreur et merci d'avance.