I had an issue running codeigniter's
It returns the last query that was run (the query string, not the result). But, remember to run the query, ie call the
get() method before the
// Some query you are having trouble building... $this->db->select('a_column'); $this->db->from('your_table'); // note, you have to call get() $query = $this->db->get(); echo $this->db->last_query(); // output the converted MySQL query
This method is helpful when having trouble building queries with the CI query class.