Zend Framework: How to do a DB select with multiple params?

zend-db, zend-db-select, zend-framework

Solution

You can use multiple where clauses which will be ANDed together by default:

$select->from('group_members')
    ->where('user_id = ?', $userId)
    ->where('group_id = ?', $groupId);

Problem

I'm just wondering what the syntax is to do a db select in Zend Framework where two values are true. Example: I want to find if a user is already a member of a group: ``` $userId = 1; $groupId = 2; $db = Zend_Db_Table::getDefaultAdapter(); $select = new Zend_Db_Select($db); $select->from('group_members') ->where('user_id = ?', $userId); //Right here. What do I do about group_id? $result = $select->query(); $resultSet = $result->fetchAll(); ```

Original source