I'm trying to debug some code in my first serious CodeIgniter app and I can't seem to find where I can simply get the raw SQL that my ActiveRecord code just generated.
$where = 'DAY(`datetime_start`) = '. date('d',$day) .' AND '; $where .= 'MONTH(`datetime_start`) = '. date('m',$day) .''; $this->db->from('events')->where($where); $result = $this->db->get();
Thanks for the help!
Before the query runs:
And after it has run:
Also, you can put the following in your controller:
You'll get queries and a lot more.