Magento Articles and Tips for Developers

$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
 
$query = 'SELECT COUNT(id) AS rows FROM table';
$sql = $readConnection->prepare($query);
$sql->execute();
$data = $sql->fetch();
printf("Rows: %d\n", $data['rows']);