MYSQL:Between! - Printable Version

MYSQL:Between! - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: MYSQL:Between! (/showthread.php?tid=10279)

MYSQL:Between! - El Forum - 07-24-2008

[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&ntilde;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?