Hello all!
I'm new to CodeIgniter and GroceryCrud and I need to build an website for a computer shop. This means that there are lots of products in different categories, each category having different attributes (like: frequency, display type, speed and so on). As far as I see the way to handle storing the products, I have 2 possibilities:
1. a `product` table which contains the general description and one table for each category (each has the columns = associated attributes).
2. a `product` table which contains the general description and a `product_description` table for adding product attributes. Please see the attached image!
Since there are more than 160 categories, I want to keep the database as simple as possible so I don't really want to apply no.1 (not to mention the complication of altering those tables if needed). So my choice will be no. 2 .
Now I'm having a problem with how to make a 2 step add/update :unsure: .
In the admin section I'll display only 'product' table, but when the user clicks the save/update buttons I want to fetch and display (also with crud) all the attributes and associated values from the `product_description` table and also having the save/update buttons.
I hope I was clear enough, if not, I can provide more pictures/details.
Thank you for your kind support!