By vijayg on

i am getting this error when i tried to insert the data from the custom form field i create:

user warning: 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 'uid`, `status`, `created`, `changed`, `comment`, `promote`, `moderate`, `sticky`' at line 1 query: INSERT INTO node (`nid`, `vid`, `type`, `language`, `title', `uid`, `status`, `created`, `changed`, `comment`, `promote`, `moderate`, `sticky`, `tnid`, `translate`) VALUES ( '62', '62', 'suggesttag', '', 'hello', 1, '', 1245402293, 1245402293, '', '', '', '', '', '') in C:\wamp\www\teagal\sites\all\modules\suggestform\suggestform.module on line 93.

I wrote a insert query as

db_query("INSERT INTO {node} (`nid`, `vid`, `type`, `language`, `title', `uid`, `status`, `created`, `changed`, `comment`, `promote`, `moderate`, `sticky`, `tnid`, `translate`) VALUES ( '$nid', '$vid', '$type', '', '$title', $uid, '', $time, $time, '', '', '', '', '', '')");

as in the query i kept some of the field empty cos i want it to be empty only..

please do have help with the question.. i m confused what should i do..

⋅ Categories: Drupal 6.x