php - mysql "insert into"SQL语法错误问题

Question

这是PHP代码:

$stringquery = "INSERT INTO sikurim(name, title, desc, category, subcategory)

 VALUES ('$contact', '$heading','$comments', '$catF', '$catS' ) ";

mysql_query($stringquery) or die(mysql_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, category, subcategory) VALUES ('jhjh', ' fffff','fffff', '2', '4' )' at line 1

我找不到代码有什么问题，有人可以帮忙吗？

Answer 1

DESC 是 reserved MySQL keyword .您需要将其括在反引号中:

$stringquery = "INSERT INTO sikurim(name, title, `desc`, category, subcategory) VALUES ('$contact', '$heading','$comments', '$catF', '$catS' )";