Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

alexmccutcheon

Archived
  • Posts

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    alex

alexmccutcheon's Achievements

  1. ok i worked out the table, but it doesn't work how i want it too...... hello i wonder if you can help me? i am setting up a lingerie site.... using categories for example bras > then sub cats for example balcony bra and half cup bra then using manufacturers for designers....the problem is i need collections or styles within the manufacturers, to load the same way sub categories do in categories. could anyone help me please? thanks in advance
  2. Ok this kind of sounds like what I need?? Basically its a lingerie site... I am using the categories for e.g. designer bras, with sub cats of balcony bra and half cup bra. BUT I am using manufacturers as designers........inside those i need collections, so like a sub category in a manufacturer. e.g. Designer x, when you click that it will list collection 1, collection 2 etc.....acting the same as sub cats. I have tried manufacturer 2 http://addons.oscommerce.com/info/2634 but it doesn't really do what I need. any ideas? thanks in advance
  3. I have downloaded version 3 and when i run the sql statement in phpmyadmin, i get this error: Error SQL-query : CREATE TABLE `manufacturers2` ( `manufacturers2_id` int( 11 ) NOT NULL auto_increment, `manufacturers2_name` varchar( 32 ) NOT NULL default '', `manufacturers2_image` varchar( 64 ) default NULL , `date_added` datetime default NULL , `last_modified` datetime default NULL , PRIMARY KEY ( `manufacturers2_id` ) , KEY `IDX_MANUFACTURERS2_NAME` ( `manufacturers2_name` ) )ENGINE = MyISAM DEFAULTCHARSET = latin1AUTO_INCREMENT = 21 MySQL said: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ' at line 9 What is wrong? the code i used was: CREATE TABLE `manufacturers2` ( `manufacturers2_id` int(11) NOT NULL auto_increment, `manufacturers2_name` varchar(32) NOT NULL default '', `manufacturers2_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`manufacturers2_id`), KEY `IDX_MANUFACTURERS2_NAME` (`manufacturers2_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; CREATE TABLE `manufacturers2_info` ( `manufacturers2_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `manufacturers2_url` varchar(255) NOT NULL default '', `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`manufacturers2_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ALTER TABLE `products` ADD `manufacturers2_id` int(11) default NULL
×
×
  • Create New...