更多PHP mySQL INSERT乐趣

Question

mysql_query("INSERT INTO dictionary ('word', 'definition') VALUES ('".$word."','".$definition."');")

That just will not execute, when I echo it - I get this:

INSERT INTO dictionary ('word', 'definition') VALUES ('monkey','monkey');

So the values are being brought into it properly, if I out put mysql_error() I get:

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 ''word', 'definition' VALUES ('monkey','monkey')' at line 1

Any ideas? I'm stumped.

Answer 1

You need to use backticks for field names:

INSERT INTO dictionary (`word`, `definition`)

(or, of course, no quotes at all. But it is better to have them.)