Displaying the SQL - Error debugging

[eluser]pickupman[/eluser]
You can use:

Code:

echo $this->db->last_query(); //display last query executed

Or in the controller change to:

Code:

function Your_controller() {
        
        parent::Controller();
        $this->output->enable_profiler('TRUE'); //Display all queries, benchmarks, $_REQUEST array
    }