表观语法错误

Question

I will be the first to admit I am bit of a newbie when it comes to PHP however I am having a really frustrating issue where I am trying to submit data which is collected from a form (currently preset in the query) and then send it to the database, my problem is that its saying my Syntax is incorrect, however from what I have found it is not and I do not have access to modify the database as it is a university server.

mysql_query("INSERT INTO 'nnProduct' VALUES ('', 'Something','Something','Something',5,5,'$image_name', $productTypeID)");

The error I am having is this

Invalid query: 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 ''nnProduct' VALUES ('', 'Something','Something','Something',5,5,'aaron.jpg', 1)' at line 1

Answer 1

You cannot wrap your table name in quotes. You need to use ticks (or no ticks or quotes):

mysql_query("INSERT INTO `nnProduct` VALUES ('', 'Something','Something',...
                       ^^^^^     ^^^^
                            HERE