Retrieving results by month...

[eluser]WanWizard[/eluser]
As per the MySQL manual, the MONTH() function requires a MySQL date as input, not a timestamp.
Try:

Code:

$this->db->where('MONTH(FROM_UNIXTIME(current_time))', $month);