MySQL syntax error in PHP

Question

$query = "INSERT INTO textbooks (uid, title, edition, author, isbn, condition, description, photo) VALUES (9, 'q', 'a', 'b', 'c', 'd', 'e', '$extension')";

$result = mysql_query($query) or die('Could not connect: ' . mysql_error());

Could not connect: 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 'condition, description, photo) VALUES (9, 'q', 'a', 'b', 'c', 'd', 'e', '.jpg')' at line 1

I've been receiving a MySQL syntax error but I can't for the life of me figure out what's wrong. I placed in random variables, strings, and int just to test but it's not working.

title, edition, author, isbn, condition, description, photo are all varchars

uid is an int

description is text

`CONDITION` is a [reserved keyword](http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html). — Wiseguy, Apr 10 '12 at 05:11

score 5 · Accepted Answer · answered Apr 10 '12 at 05:12

5

condition is reserved word in mysql. Use `condition`

answered Apr 10 '12 at 05:12

Milan Halada

1,943
18
28

score 4 · Answer 2 · answered Apr 10 '12 at 05:11

4

condition is a MySQL reserved word.

answered Apr 10 '12 at 05:11

codaddict

445,704
82
492
529

score 1 · Answer 3 · answered Apr 10 '12 at 05:11

1

Try this :

$query = "INSERT INTO `textbooks` (`uid`, `title`, `edition`, `author`, `isbn`, `condition`, `description`, `photo`) VALUES (9, 'q', 'a', 'b', 'c', 'd', 'e', '$extension')";

answered Apr 10 '12 at 05:11

Dr.Kameleon

22,532
20
115
223

score 0 · Answer 4 · answered Apr 10 '12 at 05:12

0

The phrase "condition" is a reserved word in MySQL. Just change that to something else, or use "condition", and you should be good to go.

See here for more of the words: http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

Also, is there a particular reason why you are specifying the UID manually? Auto incrementing is suitable for the majority of applications, so be sure you are utilizing that properly.

answered Apr 10 '12 at 05:12

tcole

947
6
14

I actually have an auto-incrementing id field and another uid field. The uid field is for matching the 2 tables I have in my database. – user1307016 Apr 10 '12 at 05:15

score 0 · Answer 5 · answered Apr 10 '12 at 05:15

0

condition is mySql reserved keyword so you might not use this as field name, we can use but give condition like this in query.

answered Apr 10 '12 at 05:15

Nagaraju Badaeni

890
8
14

score 0 · Answer 6 · answered Apr 10 '12 at 05:17

0

Use another word instead of condition. Or use condition.

answered Apr 10 '12 at 05:17

Santosh

11
2

MySQL syntax error in PHP

6 Answers6