error in SQL syntax (insert)

Question

Well I'm getting 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 'desc,fb_title,fb_pic,fb_url,fb_desc) VALUES('', '', '', '', '', '', '', ''' at line 1

For the following code:

$sql="INSERT INTO page(title,css,favicon,charset,keywords,author,desc,fb_title,fb_pic,fb_url,fb_desc)
VALUES('$title', '$css', '$favicon', '$charset', '$keywords', '$author', '$desc', '$fb_title', '$fb_pic', '$fb_url', '$fb_desc')";

Everything looks fine to me.. what's wrong?

Filipe Silva · Accepted Answer · 2013-11-06T16:40:15.473

2

DESC is a reserved keyword. you should put it as `DESC` to escape it.

INSERT INTO page(title,css,favicon,charset,keywords,author,`desc`,fb_title,fb_pic,fb_url,fb_desc)
  VALUES('$title', '$css', '$favicon', '$charset', '$keywords', '$author', '$desc', '$fb_title', '$fb_pic', '$fb_url', '$fb_desc')

edited Nov 06 '13 at 16:40

answered Nov 06 '13 at 16:38

Filipe Silva

21,189
5
53
68

Same 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 ''desc',fb_title,fb_pic,fb_url,fb_desc) VALUES('title', '/includes/style.css', '' at line 1 – Imri Persiado Nov 06 '13 at 16:43
it´s backticks, not singlequotes. ` not ' – Filipe Silva Nov 06 '13 at 16:45
@ImriPersiado its a backtick not single quote.. – Sumit Bijvani Nov 06 '13 at 16:45
My bad, thanks for your help! I'll accept your answer asap. – Imri Persiado Nov 06 '13 at 16:48

Shankar Narayana Damodaran · Answer 2 · 2013-11-06T16:46:26.773

1

DESC is a reserved keyword and you cannot have that as a column else surround it using a backtick operator .

Here..

$sql="INSERT INTO page(title,css,favicon,charset,keywords,author,desc,fb_t
                                                     ------------^

^{Disclaimer: Stop using mysql_* functions as they are deprecated. Switch to MySQLi or PDO instead.}

edited Nov 06 '13 at 16:46

answered Nov 06 '13 at 16:37

Shankar Narayana Damodaran

68,075
43
96
126

score 1 · Answer 3 · answered Nov 06 '13 at 16:39

Add Backtic around desc because its a reserve word

INSERT INTO page(title,css,favicon,charset,keywords,author,`desc`,fb_title,fb_pic,fb_url,fb_desc)
VALUES('$title', '$css', '$favicon', '$charset', '$keywords', '$author', '$desc', '$fb_title', '$fb_pic', '$fb_url', '$fb_desc')

Harish Singh · Answer 4 · 2013-11-06T16:41:20.320

0

desc is reserved keyword of mysql

$sql="INSERT INTO page(`title`, `css`, `favicon`, `charset`, `keywords`, `author`,`desc`,`fb_title`,`fb_pic`,`fb_url`,`fb_desc`)
VALUES('$title', '$css', '$favicon', '$charset', '$keywords', '$author', '$desc', '$fb_title', '$fb_pic', '$fb_url', '$fb_desc')";

edited Nov 06 '13 at 16:41

answered Nov 06 '13 at 16:38

Harish Singh

3,359
5
24
39

error in SQL syntax (insert)

4 Answers4