[C.Birch]

Originally posted by 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

I worked out what it was i already have in the data base useing the settings number 32 and 99 so i just edited them to 33 and 98 and it works fine now.