/**
* 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;
}
