Query Problem

[eluser]Muhammad Faisal Shabbir[/eluser]
$this->db->select(' created_on,user_id,profilepic');
$this->db->from('xyz');
$this->db->where(date_format(created_on,’%Y-%m’) < date_format(now(), ‘%Y-%m’));
$this->db->groupby(date_format(created_on,’%Y-%m’));
$this->db->orderby("created_on","desc");
i think it will work. if there are some issue then u can debug it on your local server but structure of the query will like this