[El Forum]

[eluser]elfbaba[/eluser]
Please how can i convert the below sql active record format

Code:

SELECT * FROM table WHERE t BETWEEN '2010-11-29' AND '2010-12-29'

[El Forum]

[eluser]Eric Barnes[/eluser]
How about:

Code:

$this->db->from('table')->where('t >=', '2010-11-29')->where('t <=', '2010-12-29');

or

Code:

$this->db->from('table')->where('t BETWEEN "2010-11-29" AND "2010-12-29"');

[El Forum]

[eluser]elfbaba[/eluser]
Thanks, let me try it