There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 21
STR: =================================================
SQL: The pilotshop table
=================================================
CREATE TABLE `phpvms_pilotshop` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pid` INT( 15 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`shop_type` INT( 15 ) NULL ,
`product_type` INT( 15 ) NULL ,
`image_link` TEXT NULL ,
`description` TEXT NULL ,
`price` FLOAT NULL )
The pilotshop_types table
=================================================
CREATE TABLE `phpvms_pilotshop_types` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`type` INT( 1 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`description` TEXT NULL )
The pilotshop_bought table
=================================================
CREATE TABLE `phpvms_pilotshop_bought` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pilot_id` INT( 11 ) NULL ,
`product_id` INT( 11 ) NULL )
SQL query:
The pilotshop table ================================================= CREATE TABLE `phpvms_pilotshop` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pid` INT( 15 ) NULL , `name` VARCHAR( 100 ) NULL , `shop_type` INT( 15 ) NULL , `product_type` INT( 15 ) NULL , `image_link` TEXT NULL , `description` TEXT NULL , `price` FLOAT NULL ) The pilotshop_types table ================================================= CREATE TABLE `phpvms_pilotshop_types` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `type` INT( 1 ) NULL , `name` VARCHAR( 100 ) NULL , `description` TEXT NULL ) The pilotshop_bought table ================================================= CREATE TABLE `phpvms_pilotshop_bought` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pilot_id` INT( 11 ) NULL , `product_id` INT( 11 ) NULL )
MySQL said: Documentation
#1064 - 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 'The pilotshop table
=================================================
CREATE TA' at line 1
Any ideas anyone?