The proper way to do this would be through correct database structure as you hinted. Another option is to store aluminum and wood as a JSON string array in one column. So in your database it would show item: item1, materials: {wood, aluminum}
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Coding the possibility to have multiple informations entered in our database linked to a product page. | 0 | 61 | March 12, 2019 | |
| Coding the possibility to have multiple informations entered in our database linked to a product page. | 0 | 63 | March 12, 2019 | |
| multiple categories and all them have the same filter by material | 1 | 98 | July 17, 2019 | |
| reference to many fields | 0 | 126 | March 26, 2018 | |
| Adding three related products | 7 | 503 | November 12, 2018 |