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.

Shef · Accepted Answer · 2011-07-15 21:45:41Z

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, 2011 at 21:45

Shef

45.6k15 gold badges82 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sebastian Paaske Tørholm Over a year ago

It is a keyword, you could say. Haha. Ha. I'll be going now.

Pangolin Over a year ago

@Shef, I tend to always back-tick all my field-/tablenames solves a lot of unknown problems!

Shef Over a year ago

@Nideo: So do I. I am blamed so often for that by coders who put much more weigh on readability and forget about functionality. :)

Joe Stefanelli · Accepted Answer · 2011-07-15 21:47:37Z

3

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

answered Jul 15, 2011 at 21:47

Joe Stefanelli

136k21 gold badges244 silver badges242 bronze badges

Comments

Will · Accepted Answer · 2011-07-15 21:46:38Z

0

Maybe try enclosing the column names with the grave accent?

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

answered Jul 15, 2011 at 21:46

Will

1,61915 silver badges20 bronze badges

Comments

theGame · Accepted Answer · 2011-07-15 21:49:14Z

-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, 2011 at 21:49

theGame

3934 gold badges6 silver badges18 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL Insert Query

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related