<query>
        "CREATE TABLE {$CONFIG->dbprfx}navlinks (
       navlinkid int(10) unsigned NOT NULL auto_increment,
       url varchar(200) NOT NULL default '',
       title varchar(120) NOT NULL default '',[code=sql] 
       new_window tinyint(1) unsigned NOT NULL default '0', 
       alt varchar(120) NOT NULL default '', 
       image varchar(250) NOT NULL default '', 
       link_perms varchar(120) NOT NULL default '', 
       PRIMARY KEY  (navlinkid) 
       ) TYPE=MyISAM"; 
        </query> 
 

$DB->query($query); 
 

 
SQL Layer Error: 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 '"CREATE TABLE {$CONFIG->dbprfx}navlinks ( navlinkid int(10) unsigned NOT N' at line 1 
Query [ "CREATE TABLE {$CONFIG->dbprfx}navlinks ( navlinkid int(10) unsigned NOT NULL auto_increment, url varchar(200) NOT NULL default '', title varchar(120) NOT NULL default '', new_window tinyint(1) unsigned NOT NULL default '0', alt varchar(120) NOT NULL default '', image varchar(250) NOT NULL default '', link_perms varchar(120) NOT NULL default '', PRIMARY KEY (navlinkid) ) TYPE=MyISAM";]