codeigniter query builder show sql code example

Example: how to print mysql query of codeigniter query builder

To display the query string:

print_r($this->db->last_query());    

To display the query result:

print_r($query);