$options = array('host'=> 'localhost',
'username'=> 'username',
'password'=> 'pwd',
'dbname'=> 'test'
);
$db = Zend_Db::factory('Pdo_Mysql', $options);

$result = $db->query("your query");

echo $result->fieldname;
or
echo $result['fieldname'];