Answer the question
In order to leave comments, you need to log in
How to store and display a comparison table of product parameters?
There is a table, something like take.ms/kDG68 but much more
How to store, I more or less came up with:
3 tables
product_id|name
param_id|name
product_id|param_id|value With
this query I take all the data from the database
SELECT product.product_id, param.param_id.id, compare.value FROM param AS p
LEFT OUTER JOIN compare ON product.product_id = compare.product_id
LEFT JOIN product ON param.param_id = compare.param_id
ORDER BY param.sort, param.id, product.id
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question