PHP/MySQL Insert Query

Question

For the life of me I can't get this insert query to work.

mysql_connect("**host**", "**username**", "**password**") or error("Could not connect: ".mysql_error());
mysql_select_db("**db_name**");
$db = mysql_query("INSERT INTO `pass_reset` (id,status,key,email) VALUES ('','0','$key','$email')");

It returns this error:

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 'key,email) VALUES ('','0','','')' at line 1

Could someone help me with this? I'm literally pulling my hair out over this simple query.

score 10 · Accepted Answer · answered Jul 15 '11 at 21:45

10

Try the following:

$db = mysql_query("INSERT INTO `pass_reset` (id,status,`key`,email) VALUES ('','0','$key','$email')");

Because key is a reserved word by MySQL, you must escape it with the backticks ``

answered Jul 15 '11 at 21:45

Shef

44,808
15
79
90

1

It is a `key`word, you could say. Haha. Ha. I'll be going now. – Sebastian Paaske Tørholm Jul 15 '11 at 21:47
@Shef, I tend to always back-tick all my field-/tablenames solves a lot of unknown problems! – Pangolin Jul 15 '11 at 21:49
@Nideo: So do I. I am blamed so often for that by coders who put much more weigh on readability and forget about functionality. :) – Shef Jul 15 '11 at 21:52

score 3 · Answer 2 · answered Jul 15 '11 at 21:47

3

KEY is a reserved word in MySQL, so you'd have to escape it with back ticks.

answered Jul 15 '11 at 21:47

Joe Stefanelli

132,803
19
237
235

score 0 · Answer 3 · answered Jul 15 '11 at 21:46

0

Maybe try enclosing the column names with the grave accent?

(`id`,`status`,`key`,`email`)

answered Jul 15 '11 at 21:46

Will

1,621
15
20

score -1 · Answer 4 · answered Jul 15 '11 at 21:49

-1

dont put php variable in '', it will surely work man

$db = mysql_query("INSERT INTO `pass_reset` (id,status,key,email) VALUES ('','0',$key,$email)");

Or

 $db = mysql_query("INSERT INTO `pass_reset` (id,status,key,email) VALUES ('0',$key,$email)");

answered Jul 15 '11 at 21:49

theGame

383
4
6
18

PHP/MySQL Insert Query

4 Answers4