search for: cross_sells

Displaying 1 result from an estimated 1 matches for "cross_sells".

2007 Nov 30
0
cross sell products - Options_from_collection_select ?
...CREATE TABLE products ( id INT NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, PRIMARY KEY (id) ); INSERT INTO products VALUES (1, ''alpha''); INSERT INTO products VALUES (2, ''beta''); INSERT INTO products VALUES (3, ''gamma''); CREATE TABLE cross_sells ( product_id INT NOT NULL, cross_sell_product_id INT NOT NULL, cs_position INT NOT NULL, PRIMARY KEY (product_id, cross_sell_product_id), UNIQUE KEY pos (cs_position) ); #cross sell beta(2) and gamma(3) on alpha(1) INSERT INTO cross_sells VALUES (1,2,1); INSERT INTO cross_sells VALU...