If I add the code from the .xml in via phpmyadmin, as follows.
Code:
("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
bannerid int(10) NOT NULL auto_increment,
bannername varchar(200) NOT NULL,
bannerdesc varchar(250) NOT NULL,
bannerurl varchar(250) NOT NULL,
imgurl varchar(250) NOT NULL,
bwidth mediumint(4) NOT NULL,
bheight mediumint(4) NOT NULL,
status tinyint(1) NOT NULL default '1',
PRIMARY KEY (bannerid)
)
");
I get the following error,
Code:
#1064 - You have an error in your SQL syntax near '("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
bannerid' at line 1
Please could I have some help, I'm a little new at this