[tnguy3n]

Originally Posted by EchoZA

If I add the code from the .xml in via phpmyadmin, as follows.

("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,

#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

because you didn't get the database table right.
try:

PHP Code:

CREATE TABLE IF NOT EXISTS 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)
) 


and if you have table prefix, add it before the table name.