php - date codeniter 10days from today -

i need build query show me row 10 days today(and)also if status 0

my date in table in format yyyy-mm-dd

$this->db->where('status','0')      ->where('month',date('y-m-d', strtotime('-40 days')))    ->get('installments')->result(); 

till iv come this

p.s regular queries do

try :

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