Facted Search using php and mysql Programming Web Development by anil14353 I'm trying to implementing faceted search in a Jewellery store, but failed. Problem is when try … with 999 and 3.94 gm. If you know faceted search then you can easily know what i mean. I want… Re: Facted Search using php and mysql Programming Web Development by diafol Hint - if you group on product_id - you will only ever get one row for each product_id. Re: Facted Search using php and mysql Programming Web Development by diafol OK, I can see why you'd have it like this. If you're not expecting any other attributes, you could place them in the main products table as fields in their own right: Id | Product_Code | Product_Name | metal_id | fineness | weight It may appear to be less flexible than your current setup as in order to add an attribute, you'd have to change … Re: Facted Search using php and mysql Programming Web Development by anil14353 First of all Thank you for your reply but in future we will add more attributes to the products.. Re: Facted Search using php and mysql Programming Web Development by pritaeas Can you show the code that builds your query? Re: Facted Search using php and mysql Programming Web Development by diafol >First of all Thank you for your reply but in future we will add more attributes to the products.. OK, no problem