Little help with database design (ecommerce, mysql)

[eluser]Dam1an[/eluser]
Well, you could have a common_fields table which has a row for everything, this covers things which every item will have (price and brand spring to mind)
You would then also have a common_fields table for each top level category, so you couold have tv_common_fields with size, res etc
When doing a query, you would need to join the global and category common field tables on the product ID

You can then just do a load of where clauses to get what you want