MySQL INSERT error

Question

I got this error :

Database problem occur, please try again later.
- Error in query: INSERT INTO main SET title ='', url='www.jerseymurah.com', kod='jerseymurah', owner='Hasbul Aqill', tag='jersey, football, world cup', since='Feb 2010', desc='ssfsfsfsfs'
- 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='ssfsfsfsfs'' at line 1 (Error #1064)
- File: /home/yosh/domains/yosh.my/public_html/demo/admincp/tambah-save.php

and this is my mysql query code :

$query = "INSERT INTO main SET title ='".$ttile."', url='".$url."', 
kod='".$kod."', owner='".$owner."', tag='".$tag."', since='".$since."', 
desc='".$desc."'";
$db->rq($query);

Please help and thanks a lot!

In the future, don't care about the PHP code if you get a SQL error: look at the SQL query first. PHP != SQL. — Álvaro González
– Álvaro González, Commented Dec 28, 2010 at 13:00
As an aside: Please, please, use parametrized statements, don't concatenate SQL fragments and parameters as strings, that is evil (-> SQL injection). See e.g. en.wikipedia.org/wiki/SQL_injection , and Best way to stop SQL Injection in PHP . — sleske
– sleske, Commented Mar 9, 2015 at 10:03
Also note that you are using a non-standard SQL syntax for your INSERT. It works with MySQL, so is not the cause of the error. Still, you might want to avoid DB-specific constructs unless there's no alternative. — sleske
– sleske, Commented Mar 9, 2015 at 10:05

Pekka · Accepted Answer · 2010-12-28 12:55:28Z

7

DESC is a reserved word in mySQL.

You need to put that field in backticks:

`desc`="..."

maybe consider renaming the field.

mySQL reserved words in the manual

answered Dec 28, 2010 at 12:55

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

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

Comments

Sjoerd · Accepted Answer · 2010-12-28 12:55:51Z

1

I think DESC is a reserved word, try escaping it with backticks.

answered Dec 28, 2010 at 12:55

Sjoerd

75.9k16 gold badges140 silver badges180 bronze badges

Comments

Dejan Marjanović · Accepted Answer · 2010-12-28 12:56:24Z

-1

mysql_query("INSERT INTO main(title,url,kod,owner,tag,since,description) VALUES('$title','$url','$kod','$owner','$tag','$since','$desc')");

answered Dec 28, 2010 at 12:56

Dejan Marjanović

19.4k7 gold badges54 silver badges67 bronze badges

Collectives™ on Stack Overflow

MySQL INSERT error

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related