mySQL Parse Error

From: Date: Mon, 22 Mar 2004 13:20:03 +0000
Subject: mySQL Parse Error
Groups: php.db 
Request: Send a blank email to php-db+get-33596@lists.php.net to get a copy of this message
Hi, I have a table: CREATE TABLE cashmire (id smallint(3) unsigned NOT NULL auto_increment, itemcode varchar(25) NOT NULL default '', collection char(2) NOT NULL default 'cl', promotion char(1) default 'n', bestSeller char(1) default 'n', newArrival char(1) default 'n', size varchar(15) default NULL, colour varchar(30) default NULL, image varchar(7) default NULL, currency char(3) default 'MRS', price mediumint(8) unsigned NOT NULL default '0', description text, purchased smallint(3) unsigned default NULL, PRIMARY KEY (id), UNIQUE KEY itemcode (itemcode), ) TYPE=MyISAM; When i run this SQL: insert into cashmire ('itemcode', 'collection', 'promotion', 'bestSeller', 'newArrival', 'size', 'color', 'image', 'currency', 'price', 'description', 'purchased') values ('31474', 'cl', 'n', 'n', 'y', 'S-M-L-XL', 'AQ-BL-EC', '', 'MRS', '8400', 'Long sleeve chunky roll neck cardigan (12 ply) with high ribbed welt and turn-back cuffs, authentic coconut buttons', '0') I get: 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 ''itemcode', 'collection', 'promotion', 'bestSeller', 'newArriva I can't understand... tried googling but still no answer! Can someone help me please, regards, nadim attari

« previous php.db (#33596) next »