Journal

Journal

Those who need it to accomplish some task or goal.

Ad comes here
Ad comes here
Ad comes here
Ad comes here
Ad comes here
Ad comes here
Ad comes here
Ad comes here
Ad comes here

How to run custom MySql query in Magento ?

$db = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);
$result=$db->query(“SELECT * FROM PCDSTable”);


$connect = Mage::getSingleton('core/resource')->getConnection('core_read');
$result=$db->query(“SELECT id FROM `customer_wishlists` WHERE `type`='wishlist'");

Ad comes here
Error's and solution's