[xs1]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'Help Forum','HELPforum','1','The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)','','15')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'User Question Answered','HELPdone','<i>[Answered]</i>&nbsp;','The name of the prefix for thread where the user has been helped!','','16')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'User Question Unanswered','HELPundone','<i>[Un-Answered]</i>&nbsp;','The name of the prefix for the thread where the user is awaiting help!','','17')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'Help Thread Status','HELPopen','0','Close that particular thread once help is provided?','yesno','18')
ALTER TABLE thread ADD helpoption smallint(6) NOT NULL DEFAULT '0'

got this error when i queried the above

Error

SQL-query :

INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (

NULL , 9, 'Help Forum', 'HELPforum', '1', 'The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)', '', '15'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'User Question Answered', 'HELPdone', '<i>[Answered]</i>&nbsp;', 'The name of the prefix for thread where the user has been helped!', '', '16'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'User Question Unanswered', 'HELPundone', '<i>[Un-Answered]</i>&nbsp;', 'The name of the prefix for the thread where the user is awaiting help!', '', '17'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'Help Thread Status', 'HELPopen', '0', 'Close that particular thread once help is provided?', 'yesno', '18'
)
ALTER TABLE thread ADD helpoption smallint( 6 ) NOT NULL DEFAULT '0'

MySQL said:

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 'INSERT INTO setting( settingid, settinggroupid, title, varname