public function between($field, $value1, $value2, $type = '', $and_or = 'AND')
{
if (is_null($this->where)) {
$this->where = $field . ' ' . $type . 'BETWEEN ' . $this->escape($value1) . ' AND ' . $this->escape($value2);
} else {
$this->where = $this->where . ' ' . $and_or . ' ' . $field . ' ' . $type . 'BETWEEN ' . $this->escape($value1) . ' AND ' . $this->escape($value2);
}
return $this;
}