Andybird Posted January 12, 2007 Share Posted January 12, 2007 Hi guys, I have two websites, at two different locations, sharing the same data base. Though, I would like to have two different products related tables. Would someone explain what should be changed in the search modules so that the search is made in both product related tables? Thanks for your help. Andybird Link to comment Share on other sites More sharing options...
Andybird Posted January 12, 2007 Author Share Posted January 12, 2007 Me again. I presume the change must be opperated somwhere at ligne 213 in advanced_search_result.php at this level: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; …adding somewhere the TABLE_PRODUCTS_NEW and TABLE_PRODUCTS_DESCRIPTIN_NEW. Unfortunately, I’m not good enough with php programming to do that by my own… Any help would be highly appreciated. Thanks, Andybird. Link to comment Share on other sites More sharing options...
Andybird Posted January 13, 2007 Author Share Posted January 13, 2007 Sorry for my persistance... any ideas??? Thanks, Andybird Link to comment Share on other sites More sharing options...
Guest Posted January 13, 2007 Share Posted January 13, 2007 its not just you return results from both tables but then you need to process the user interaction which makes what you ask very complicated. Basically every script that access products in your stores has to be moded. Check the multi-store related contributions you may find something that's simpler to implement. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.