/----------Get products collection --------------/
<p>$allproducts = Mage::getModel('catalog/product')->getCollection()->addAttributeToSort('name', 'ASC');;</p>
It will return you total products, sorted by name in ascending order from magento database.
To print query write the below statement :-
<p>echo $allproducts->getSelect();</p>
0 Comment(s)