I have a product with 3 attributes(color,size,brand) and some other attributes.
I need to display above 3 attributes in a table with unique rows.
For example product1 values: green,12,samsung
product2 values :yellow,12,samsung
product3 vaules:green,12,samsung.
So I need to get only (product1 or product3 ) & product2 from collection.
(because product1 & product3 all values are same.So i want to avoid duplicate rows)
and my sample code:
$collection=Mage::getResourceModel('catalog/product_collection')->distinct(true);
How to write query to get above one. Can any one help this ? Thanks in advance.