Mais ou est mon erreur de syntax?

Bonjour,
Voila ce qui m'est rtourné

Citation:

---

Erreur SQL ! INSERT INTO users_education(id,id_owner,lang,education_name,where,years) VALUES("","$_SESSION['staff_id']","en","htmlentities($f_education_name_en)","htmlentities($f_where_en)","f_years")
You have an error in your SQL syntax near 'where,years) VALUES("","$_SESSION['staff_id']","en","htmlentities($f_education_n' at line 1

---

mon code

Code:

---

1 2 3

$sql_insert = 'INSERT INTO users_education(id,id_owner,lang,education_name,where,years)VALUES("","$_SESSION[\'staff_id\']","en","htmlentities($f_education_name_en)","htmlentities($f_where_en)","f_years")'; mysql_query($sql_insert) or die('Erreur SQL ! '.$sql_insert.'<br />'.mysql_error());

---

a mon avis évite d'utiliser where comme nom.

Citation:

---

Envoyé par Death83

a mon avis évite d'utiliser where comme nom.

---

Je confirme... au pire essaie de mettre les noms de champs entre backquotes. Mais c'est une TRES mauvaise idée d'utiliser les mots réservés du langage.

Pour moi l'erreur vient de

Code:

---

("","$_SESSION['staff_id']","en","htmlentities($f_education_name_en)","htmlentities($f_where_en)","f_years")

---

Solution possible :

Code:

---

("","{$_SESSION['staff_id']}","en","{htmlentities($f_education_name_en)}","{htmlentities($f_where_en)}","f_years")

---

Citation:

---

Envoyé par simmstein

Pour moi l'erreur vient de

Code:

---

("","$_SESSION['staff_id']","en","htmlentities($f_education_name_en)","htmlentities($f_where_en)","f_years")

---

Solution possible :

Code:

---

("","{$_SESSION['staff_id']}","en","{htmlentities($f_education_name_en)}","{htmlentities($f_where_en)}","f_years")

---

---

C'est vrai que mysql_error() aime fourvoyer les développeurs en donnant de mauvaises indications d'erreurs.

Comme les autres, sinon, très mauvaise idée d'utiliser un nom de champ identique à un de la syntaxe SQL.

Meci pour vos reponse

J'ai en effet remplacer le "where" par un autre nom