51

Re: Tjapnichnyj search of the goods in a dial-up of attributes

He forgot grouping of the goods, that in group of the goods of Televizory\Televizory
Tovar
tov_id, tov_name
1, TV Gnusmas 40 "FullHD
Category
cat_id, cat_name
2, the Diagonal
3, Resolution
6, the TV set
7, TV set ZHK
Value
val_id, cat_id, val_name
4,2,39 "-43"
5,3, FullHD
8,6, the TV set
9,7, TV set ZHK
Attribute
tov_id, val_id
1,4
1,5
1,8
1,9

52

Re: Tjapnichnyj search of the goods in a dial-up of attributes

Still thought, it is more convenient for  so to store
Tovar
tov_id, tov_name
1, TV Gnusmas 40 "FullHD
Category
cat_id, cat_name
2, the Diagonal
3, Resolution
6, Group of the goods
Value
val_id, cat_id, val_name
4,2,39 "-43"
5,3, FullHD
8,6, the TV set
9,6, TV set ZHK
Attribute
tov_id, val_id
1,4
1,5
1,8
1,9
[/quote]

53

Re: Tjapnichnyj search of the goods in a dial-up of attributes

. I a little not so used Category.
A bit later .