Welcome Guest, Not a member yet? Register   Sign In
MYSQL:Between!
#1

[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?




Theme © iAndrew 2016 - Forum software by © MyBB