Help me to solve database problem in codeigniter

[eluser][email protected][/eluser]
Thanks dude it's working it's really helpful to me. Actually there is only one change ie. as you said to use code below:

Code:

$this->db()
  ->select(‘MONTHNAME(`time`) as Month_name, YEAR(`time`) as Year_no, COUNT(*)’)
  ->from(articles)
  ->group_by(‘MONTHNAME(`time`)’,‘DESC’)
  ->order_by(‘id’,‘DESC’)
  ->limit(0,6)
  ->get();
{

But it's show error then i try put every database column individually

Code:

$this->db->select('MONTHNAME(time) as month_name');
$this->db->select('YEAR(time) as year_no');
$this->db->select('COUNT(*) as number');
$this->db->group_by('Year(time)');
$this->db->order_by('id', 'DESC');
$query = $this->db->get('articles');

All idea is your so it can't be possible to me without your help. So thanks again buddy