How to set db connection in magento

<?php
$con = Mage::getSingleton('core/resource')->getConnection('core_write');

/*------------------------------------ select query*/
$re=$con->query('select * from teble_name');
while($rows=$re->fetch())
{
$rows['field_name'];
}
?>