Product filtering

At the moment my product catalog is displayed in ListView and I was wondering how I c开发者_开发技巧an do a product filter based on category, price range, etc. in text on my sidebar. Below is an example of what I am referring to. I've tried googling for some answers but couldn't quite find what I wanted to do.

Perhaps you could make a string with the ID's of the selected products in. And insert that in your SQL Statement.

SELECT * FROM PRODUCTS WHERE CategoryID = (idString) AND Price = (idString);