I'm trying to load a couple tons of data into a shopping cart system and for some reason it keeps kicking back with an error. I'm too dumb to figure out why. Can anyone tell me what's wrong with this code and why it doesn't work?
INSERT INTO 'products' VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '0000-00-00 00:00:00', '0.00', 1, 1, 1, 0); The table itself looks like this CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) TYPE=MyISAM AUTO_INCREMENT=30 ; and I myself look like http://www.dibcomputers.com/images/headbang.gif at the moment. ;) TIA!
