[PHP-DB] mySQL Parse Error

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`

Re: [PHP-DB] mySQL Parse Error

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`

Re: [PHP-DB] mySQL Parse Error

Your field name is 'colour', you are inserting into 'color' ? --Original 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

Re: [PHP-DB] mySQL Parse Error

You are also trying to insert '8400' (characters) into a mediumint (price)? --Original 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

Re: [PHP-DB] mySQL Parse Error

Nadim Attari wrote: insert into cashmire ('itemcode', 'collection', 'promotion', 'bestSeller', You should not have quotes around the column names. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com

Re: [PHP-DB] mySQL Parse Error

You should not have quotes around the column names. Yea. that was the problem... 'color' a was trivial error ! i got it at home after office hours!!! Seems that a break is necessary when things go wrong !!! Thnx Nadim Attari -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,