/** * method to get requests by field * @param type $by */ public static function getRequests($filterValue, $filterBy = 'request_id', $fields = array(), $where = array(), $orderBy = 'id DESC', $limit = 1) { $tbl = new Application_Model_DbTable_Requests(Np_Db::slave()); $select = $tbl->select()->from($tbl->info(Zend_Db_Table_Abstract::NAME), $fields); $select->where($tbl->getAdapter()->quoteIdentifier($filterBy) . ' = ?', $filterValue)->order($orderBy)->limit(intval($limit)); foreach ($where as $cond => $value) { $select->where($cond, $value); } // print($select); return $select->query()->fetchAll(); }