Laico Posted June 1, 2007 Share Posted June 1, 2007 For each product, its category is recorded in the "cat_id" column in the "cubecart_inventory" table. The same information seems to be duplicated in the "cubecart_cats_idx" table. Does anyone know the purpose of that second table? Quote Link to comment Share on other sites More sharing options...
Guest EverythingWeb Posted June 1, 2007 Share Posted June 1, 2007 For products that exist in multiple categories :( Quote Link to comment Share on other sites More sharing options...
Laico Posted June 1, 2007 Author Share Posted June 1, 2007 Thanks for the reply! So if that table is available for representing product categories, then why is there the field cubecart_inventory.cat_id? (After all, a product in only one category still has an entry in the "cubecart_cats_idx" table.) Quote Link to comment Share on other sites More sharing options...
markscarts Posted June 3, 2007 Share Posted June 3, 2007 Because, that is the actual product category (master category) The idx (index) is then a cross-index for multiple categories being assigned to a product. The products master category is of course listed there, the the product is assigned to that master category. product added is ASSIGNED to one category, master category. Multiple categories may be ASSIGNED to existing product, this is tracked by the index table Quote Link to comment Share on other sites More sharing options...
Guest screentekdvd Posted October 5, 2010 Share Posted October 5, 2010 On this subject How can I count the number of product assigned to each category and display it thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.