Help me to solve database problem in codeigniter

[eluser][email protected][/eluser]
Hi,

I am new in CodeIgniter trying to create a small article's website for practice. All articles are coming from database every thing is working fine but in One query i got confuse i don't know how to call it by active record and use it in my view are following:

Code:

SELECT MONTHNAME(`time`), YEAR(`time`), COUNT(*)
FROM `articles`
GROUP BY MONTHNAME(`time`)
ORDER BY `id` DESC
LIMIT 0, 6;

Here i want to group my articles by month and get count of article in a particular month. But i have no idea how to implement it in my module and get records in my view. I have main problem in sql functions ie. MONTHNAME(`time`)