latest Update 2021

$w = Mage::getSingleton('core/resource')->getConnection('core_write'); $result = $w->query('select name from shop_franchise'); $row = $result->fetch(PDO::FETCH_ASSOC); if ($row) { print_r($row); }