/** * Returns array of row objects. * @param mixed $where - unlike the other "*Where" methods you may specify a string where clause * @see dbHelper::joinWhere() for $where formatting * @param mixed $andor * @see dbHelper::andOr() for more info on $andor formatting * @param int $limit * * @return array(dbRow) */ public function loadRowsWhere($where, $andor = 'AND', $limit = '') { if (is_array($where)) { $where = dbHelper::joinWhere($where, $andor); } $data = db::qryAssoc("SELECT * FROM {$this->tableName} WHERE {$where} {$limit}"); //adds to row cache dbData::addRows($this->tableName, $this->primaryKey, $data); $ret = array(); foreach ($data as $r) { //get loaded from row cache $ret[] = dbRow::getRow($this->tableName, $this->primaryKey, $r[$this->primaryKey]); } return $ret; }