i've wanted to count row results to build a nice helper which organizes my index-views more comfortable.

so i've added ..

    /**
     * Fetches the number of row results.
     * 
     * @return int The number of row results
     */
    public function fetchCount($where = null)
    {
        return (int)$this->_fetch('Count', $where);
    }    

.. and changed ..

        // the FROM clause
        $select->from($this->_name, array_keys($this->_cols));

.. to ..

        // the FROM clause
        if ($type == 'Count') {
            $select->from($this->_name, 'count(*)');
            $type = 'One';
        }
        else
            $select->from($this->_name, array_keys($this->_cols));

.. which gives me a Zend_Db_Table::fetchCount($where)-function returning the number of row results :)