// display all regions defined for the United States $sql = "SELECT * FROM directory_country_region WHERE country_id='US'"; $connection = Mage::getSingleton('core/resource')->getConnection('core_read'); foreach ($connection->fetchAll($sql) as $arr_row) { echo $arr_row['default_name']; }
for more magento tutorial visit: http://blog.free-extension.com/