php - MySQL syntax error #1064 - INSERT -


error:

1064: have error in sql syntax; check manual corresponds mysql server version right syntax use near '(id, name, url, content, category) articles values (null, 'names', 'names', 'text' @ line 1

php code:

$sql = "insert (id, name, url, content, category) articles values (null, '$name', '$url', '$content', '$category')"; $insert = mysql_query($sql); 

and mysql database table:

id primary  tinyint(20)     unsigned   auto_increment  name        varchar(255)    utf8_general_ci url         varchar(255)    utf8_general_ci content     longtext        utf8_general_ci category    varchar(255)    utf8_general_ci 

you got first half of query backwards. first table insert into, then list fields receive values.

$sql = "insert articles (id, name, url, content, category) values (null, '$name', '$url', '$content', '$category')"; 

Comments