--------------------------------
[product_no]_________ [filter]
1______________ _______2BG RAM
1______________ _______INTEL
1______________ _______100 GBHD
2______________ _______2GB RAM
2______________ _______AMD
3______________ _______120 GBHD
4______________ _______4GB RAM
4______________ ________AMD

1. problem
i need like this:
[filter]_____[product...

New simply table.

[CODE=mysql]

CREATE TABLE z (
product_no int(11) unsigned NOT NULL,
category_no int(11) unsigned NOT NULL,
PRIMARY KEY (`product_no`,` category_no`)
);

INSERT INTO z(product_no, category_no)
VALUES (1, 68),
(1, 72),
(2, 68),
(2, 72),
(2, 127),
(2, 130),
(2, 133),...

Thanks for reply and my bad english sorry.
i want like above

(picture 1) i click installed ram, al least 1 gb then recount other filters with al least 1 gb ram.

in my table i cant count products. my theroical sql

[CODE=mysql]
select category_no,cou nt(product_no) from filter
where HOW together? category_no=68
group by category_no
[/CODE]

[CODE=mysql]...

Hi All,
I cant product filtering. Please help.

CREATE TABLE filter (
product_no int(11) unsigned NOT NULL,
category_no int(11) unsigned NOT NULL,
PRIMARY KEY (product_no,cat egory_no)
);

INSERT INTO filter (product_no,cat egory_no)VALUES (1,68),(1,72),( 1,88),(1,97),(1 ,104),(1,117),( 1,124),(1,126), (1,130),(1,133) ,(2,68),(2,72), (2,88),(2,97),( 2,104),(2,117), (2,124),(2,127) ,(2,130),(2,133 ),(3,68),(3,73) ,(3,89),(3,97), (3,104),(3,117) ,(3,123),(3,126 ),(3,129),(3,13 3),(4,68),(4,72 ),(4,90),(4,95) ,(4,103),(4,117 ),(4,124),(4,12 7),(4,129),(4,1 33),(5,68),(5,7 3),(5,90),(5,95 ),(5,102),(5,11 7),(5,124),(5,1 27),(5,129),(5, 133),(6,68),(6, 73),(6,90),(6,9 5),(6,102),(6,1 17),(6,123),(6, 126),(6,129),(6 ,132);...