[eluser]MMCCQQ[/eluser]
how can i use Between in CI?
i want do this..
Code:
$query = "SELECT * FROM WHERE idTipo = ".$_POST['tipo']." AND PRICES BETWEEN ".$_POST['prices2']." AND ".$_POST['prices3']."";
and i want integrate with this:
Code:
$this->db->join('caracteristicas c','c.Caracteristica = Baños');
$this->db->join('detallecaracteristica dc', 'dc.idCaracteristica = c.idCaracteristica ');
$this->db->join('propiedades p','p.idPropiedad = dc.idPropiedad');
$this->db->where('dc.Cantidad',$_POST['bano']);
$this->db->where('idTipo', $_POST['tipo']);
who can i helpme?