Count rows with Zend_Db

There are several ways to count rows in a table using the Zend_Db component. The first way is to fetch the rows in a row set object and run count() on it. As you see it isn’t really smart to build a row set object if you just want to know the number of rows. There is a better way:

$query = $db->select()->from('my_table', 'count(*)');
$numRows = $db->fetchOne($query);


You can perfectly embed this in your table model and use “where” conditions and joins to get the right numbers.

Regards to Justin Plock for this one.