Quela'un pourrai-t-il me dire ou est l'erreur de syntax svp??
merci
$fill_db = sprintf("INSERT INTO user (`nom`, `prenom`, `login`, `adresse`, `cp`, `ville`, `email`, `pass`, `repass`, `date`) VALUES ('%s', '%s','%s','%s','%d', '%s''%s','%s',,'%s', '%d')", mysql_real_escape_string($nom, $link),
mysql_real_escape_string($prenom, $link),
mysql_real_escape_string($login, $link),
mysql_real_escape_string($adresse, $link),
$cp,
mysql_real_escape_string($ville, $link),
mysql_real_escape_string($email, $link),
mysql_real_escape_string($pass, $link),
mysql_real_escape_string($repass, $link),
$date);
erreur afficher :
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''allo', '6')' at line 1
nan en fait c une virufle oubliee mais une otre erreur saffiche:
voila la requete securise:$fill_db = sprintf("INSERT INTO user (`nom`, `prenom`, `login`, `adresse`, `cp`, `ville`, `email`, `pass`, `repass`, `date`) VALUES ('%s', '%s','%s','%s','%d', '%s''%s','%s','%s', '%d')", mysql_real_escape_string($nom, $link),
mysql_real_escape_string($prenom, $link),
mysql_real_escape_string($login, $link),
mysql_real_escape_string($adresse, $link),
$cp,
mysql_real_escape_string($ville, $link),
mysql_real_escape_string($email, $link),
mysql_real_escape_string($pass, $link),
mysql_real_escape_string($repass, $link),
$date);
et l'erreur:
Column count doesn't match value count at row 1
---------------
L'etre humain juge tres vite comprend lentement, s'enerve facilement et perd vite ses facultees d'enfant!!!!