I'm designing a flooring website for a local company and I have an idea of how to manage the data for:
Hardwood
Laminate
Carpet and
Vinyl
It is laid out in this order
Product Floortype(hardwood, laminate, vinyl, etc)
|
|
----Brand of Product (Shaw, Zickgraf, wahtever)
|
|
-------Style of Product (Longly, Leafy, Style Number2, etc)
|
|
-----------Color of Product(Green, Blue, Red, wahtever)
|
|
|
----------Then the product is displayed with whatever attributes it may have.......as well as the price of that ONE product...
This isn't a problem for me to create
My problem is the rugs floortype.....it is laid out like this
CODE
Product Floortype(rug)
|
|
----Brand of Product (Shaw, Zickgraf, wahtever)
|
|
-------Style of Product (Longly, Leafy, Style Number2, etc)
|
|
-----------Color of Product(Green, Blue, Red, wahtever)
|
|
|
----------Then here it will show all the attributes of that type of rugs as well as all the different types of sizes with a price for each size.
I want to be able to hold all the products in one mysql table.......including the rugs....
I would be including all the attributes of every product in a row of it's own......how would you recommend I lay out the various rugs sizes and prices in one row as well.
If you need a more in depth look......
check out
http://www.ifloor.com and go through the process of selecting a hardwood product...then go back and select a rug.... As you do both think about how you would lay out such data....and how you would make it easy for someone to update it in a control panel
Thanks in advance
Start Free Trial
