Question

用ci怎么写关于between and的sql语句

Answer 1

--示例：select prod_name,prod_price from table_name where prod_price between 1 and 5;
$this->db->select('prod_name,prod_price');
$this->db->where('prod_price between 5 and 1');
$this->db->get('table_name');