BrighteyesDesign
asked on
Best way to display a sub sub menu
I have a product database working fine.
Products are assigned a main category and a sub category.
What I need to add are product options so the 'rosary beads' sub category will have colour options...red, black, white etc...
I'm wondering what is the best way to do this? A separate 'options' table with the id from the product table?
So the table would be something like...
id option
13 red
13 black
13 white
14 large
14 medium
14 small
Screen-shot-2012-03-30-at-18.13..png
Products are assigned a main category and a sub category.
What I need to add are product options so the 'rosary beads' sub category will have colour options...red, black, white etc...
I'm wondering what is the best way to do this? A separate 'options' table with the id from the product table?
So the table would be something like...
id option
13 red
13 black
13 white
14 large
14 medium
14 small
Screen-shot-2012-03-30-at-18.13..png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER