(NBBS) Reading Topic: creating atable with XML

Posted on Jul 26, 2006, 12:53 am by harmor Link to this Post \| #4590
creating atable with XML

In my XML file I have

xml Code:

 
        <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>

In my php file I have

php Code:

$DB->query($query);

I always get this error

error Code:

 
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";]

Here are the full scripts

Attachement

168.xml

Attachement

167.php

Last edit by harmor on Jul 26, 2006, 12:54 am

Xen Web Hosting Offering ad-free hosting with features such as, cpanel, fantastico, PHP and MySQL support, and more -------------------------------------------------------------------------------------------------------

Chris

Let's hang on to Harmor, it's not everyday that you find people who walk the walk, not just talk the talk.