[C.Birch]

im having a really big prob adding anything to my database via phpmyadmin

eg try adding:

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,'vBaffiliates','99')


Get:
Error
SQL-query : [Edit]

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (32,\'vBaffiliates\',\'99\')

MySQL said:


You have an error in your SQL syntax near '\'vBaffiliates\',\'99\')' at line 1


Try:
CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT '0' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT '0' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;


Get:
Error
SQL-query : [Edit]

CREATE TABLE `vbaffiliates` (
`linkid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`link` VARCHAR(150) NOT NULL,
`b_link` VARCHAR(150) NOT NULL,
`moderated` smallint(6) DEFAULT \'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
`hits` smallint(6) DEFAULT \'0\' NOT NULL,
`userid` smallint(6) NOT NULL
) TYPE = MYISAM;

MySQL said:


You have an error in your SQL syntax near '\'0\' NOT NULL,
`height` smallint(6) NOT NULL,
`width` smallint(6) NOT NULL,
' at line 6


can someone help its doing it for almost everything i try that needs database work but it never used to