CODEWITHSUNDEEP
phpmysql
nitsuj
nitsuj

Reputation: 780

ERROR When trying to insert into MySQL table with PHP

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?

Upvotes: 1

Views: 69

Answers (2)

bfavaretto
bfavaretto

Reputation: 71918

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')");

Upvotes: 6

user1233508
user1233508

Reputation:

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.

Upvotes: 3

Related Questions