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
Post a Comment