MYSQL and UNIX timestamps...

[eluser]mddd[/eluser]
I think that is your own preference. Some people like the CI stuff, some like to write SQL their own way.
Using the CI class it would be:

Code:

// $year and $month are the terms you are searching for
$this->db->where('year(from_unixtime(date))', $year, false);
$this->db->where('month(from_unixtime(date))', $month, false);
$result_array = $this->db->get('events')->result_array();