[RESOLVED] zend framework select where not working

[thepreacher]

I have the following that is to fetch only records that have the field "loan_cycle_number" = 0; yet it still fetches all the records. I have googled all I can and still no solution found:

        

        $groups = new Application_Model_GroupsMapper();
        $db = $groups->getDbTable()->select();
        $select->where('loan_cycle_number = ?', 0);

    $rows = $groups->fetchAll($select);

the getDbTable method is like so

    public function getDbTable()
    {
        if (null === $this->_dbTable) {
            $this->setDbTable('Application_Model_DbTable_Groups');
        }
        return $this->_dbTable;
    }

Thanks

[thepreacher]

sorry guys i posted a wrong code it should be;

        $groups = new Application_Model_GroupsMapper();
        $select = $groups->getDbTable()->select();
        $select->where('loan_cycle_number = ?', 0);

    $rows = $groups->fetchAll($select);

[dagon]

try

$select->where('loan_cycle_number = 0');

both versions can be used

[thepreacher]

well in the end the following code from someone from another forum worked for me. I don't know what is different from my apart from the structure but hey I am not complaining.

<?php
$groups = new Application_Model_GroupsMapper;
$rows = $groups->getDbTable()->fetchAll(
    $groups->getDbTable()->select()->where('loan_cycle_number = ?', 0)
);
?>