[eluser]Unknown[/eluser]
This may be a newbie question, but something I can't find in the docs very easily:
Is there a way to see a query string that's built before actually running the query? I know last_query shows you what was run, but for debugging, I'd like to see it without actually submitting it.
$data = array(
'myfield1' => $EmployeeNo,
'myfield2' => date("Y-m-d")
);
$this->db->where('recordno', $RecordNumber);
$this->db->update('propertytable', $data);
This will actually execute the query -- how do I just get a string of what the query will look like to confirm it's being built correctly with my data?