display product in magento with sql in list.phtml file
Place this following code in your phtml file where you want to display particular category products this will return array of products and you can use this array to display product of particular category. $sql = “SELECT product_id FROM catalog_category_product WHERE category_id=57″;$data = Mage::getSingleton(‘core/resource’) ->getConnection(‘core_read’)->fetchAll($sql); Happy Coding…
Recent Comments