Error in your SQL syntax; check the manual that corresponds to y
mina
-
mpmp93 Messages postés 7217 Date d'inscription Statut Membre Dernière intervention -
mpmp93 Messages postés 7217 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
moi code est :if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO client(nom, prénom, email, password, adresse, wilaya, telephone, credit) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['nom'], "text"),
GetSQLValueString($_POST['prénom'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['password'], "text"),
GetSQLValueString($_POST['adresse'], "text"),
GetSQLValueString($_POST['wilaya'], "text"),
GetSQLValueString($_POST['telephone'], "int"),
GetSQLValueString($_POST['credit'], "double"));
mysql_select_db($database_ventes, $ventes);
$Result1 = mysql_query($insertSQL, $ventes) or die(mysql_error());
}
est le problem: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 '©nom, email, password, adresse, wilaya, telephone, credit) VALUES (NULL, NULL, ' at line 1
moi code est :if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO client(nom, prénom, email, password, adresse, wilaya, telephone, credit) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['nom'], "text"),
GetSQLValueString($_POST['prénom'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['password'], "text"),
GetSQLValueString($_POST['adresse'], "text"),
GetSQLValueString($_POST['wilaya'], "text"),
GetSQLValueString($_POST['telephone'], "int"),
GetSQLValueString($_POST['credit'], "double"));
mysql_select_db($database_ventes, $ventes);
$Result1 = mysql_query($insertSQL, $ventes) or die(mysql_error());
}
est le problem: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 '©nom, email, password, adresse, wilaya, telephone, credit) VALUES (NULL, NULL, ' at line 1
A voir également:
- Check the manual that corresponds to your mariadb server version for the right syntax
- Downloader for pc - Télécharger - Téléchargement & Transfert
- Dernière version ccleaner gratuit français - Télécharger - Nettoyage
- Splitcam ancienne version - Télécharger - Messagerie
- Qwerty to azerty - Guide
- This is a system-generated message to inform you that your email could not be delivered to one or more recipients. details of the email and the error are as follows: ✓ - Forum Mail