Magento: custom sql Query example

$read = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
$pincode = Mage::getSingleton( 'core/resource' )->getTableName( 'available_pincodes' );
$query = "SELECT * FROM " . $pincode ;
$result = $read->query( $query );
while ( $row = $result->fetch() ) {
echo 'Pincode ID: ' . $row['pincode_value'] . '
';
}
?>

Or

DB Connection Code :

——————————————————————————————————————

include_once ('../app/Mage.php');

umask(0);

Mage::app('default');

——————————————————————————————————————

loop:

——————————————————————————————————————

$conn = Mage::getSingleton('core/resource')->getConnection('core_read');

$results = $conn->fetchAll("SELECT * FROM epic_affiliate_code WHERE 1;");

foreach($results as $row) {

echo $row['email_id'] . "\n";

}