ERROR When trying to insert into MySQL table with PHP

Question

I don't know what's wrong with my syntax, but I'm missing something:

$createrequest = mysql_query("INSERT INTO products_updates_queue (id, kid,
product_version_id, key, ip) VALUES ('$request_id', '$uid', '$version_id',
'$request_key', '$request_ip')");

I receive 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, ip) VALUES ('j4ctveyd0x62', '1', 'z451ah3', 'hqbyu7bhg8za', '64.134.163.2' at line 2"

Can anyone see what I am missing?

bfavaretto · Accepted Answer · 2012-03-06 20:31:57Z

6

I think key is a reserved word, and you should avoid using it as a column name. Try using backticks around it:

$createrequest = mysql_query("INSERT INTO products_updates_queue (id, uid, product_version_id, `key`, ip) VALUES ('$request_id', '$uid', '$version_id', '$request_key', '$request_ip')");

answered Mar 6, 2012 at 20:31

bfavaretto

72k18 gold badges118 silver badges162 bronze badges

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

3 Comments

James Glass Over a year ago

+1 for suggesting avoiding using it as a column name (Better solution then always having to wrap it in backticks)

nitsuj Over a year ago

Thanks for your reply! I saw the solution from @DCoder before yours, but I will accept yours so that others (if they have the same problem), will know to avoid using this column name.

bfavaretto Over a year ago

The other user also tells you to avoid it. Feel free to accept the answer you like the most!

user1233508 · Accepted Answer · 2012-03-06 20:31:36Z

3

key is a reserved word in MySQL. Avoid it, or wrap it in backticks.

Edit: And I hope you escaped the variables you're putting into that query.

answered Mar 6, 2012 at 20:31

user1233508

Collectives™ on Stack Overflow

ERROR When trying to insert into MySQL table with PHP

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related