SQL Query

[andrew4545]

Hi I'm trying to add more zones to shop,

 

I've tried using this contribution

http://addons.oscommerce.com/info/1792

 

But when I run the SQL query I get this error

 

Unable to execute query: 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 zones ( zone_id int NOT NULL auto_increment, zone_country_' at line 1

 

Oh this is the query im running;

 

DROP TABLE IF EXISTS zones;

CREATE TABLE zones (

zone_id int NOT NULL auto_increment,

zone_country_id int NOT NULL,

zone_code varchar(32) NOT NULL,

zone_name varchar(32) NOT NULL,

PRIMARY KEY (zone_id)

);

 

#Afghanistan

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',1,'BA','Badakhshan');

 

if anyone knows what I'm doing wrong or even if they know a query that will add to what I've got that would be great.

 

Thanks in advance for any help :thumbsup: