datecodeigniter从今天起10天

Question

i need to build a query that will show me all row 10 days from today(AND)also if status is 0

my date in the table is in format yyyy-mm-dd

$this->db->where('status','0')

    ->where('month',date('Y-m-d', strtotime('-40 days')))

  ->get('installments')->result();

till now iv only come up with this

p.s Regular Queries will also Do

Answer 1

Try this :

 $this->db->where('status','0')
->where("month >=","CURDATE()", false)
        ->where("month <=","current_date + interval '10' day", false)
        ->get('installments')->result();