Seeing query before submitting

[eluser]bretticus[/eluser]
The following code works for SELECT statements. Not sure on an UPDATE so your mileage may vary. Feel free to try it and post if it works:

Code:

// get compiled select statement
$compiled_query = $this->db->_compile_select();
echo $compiled_query;

EDIT...Problem may be that you need to call it before calling update. Hmmm????

On second thought, call it before update(). At least you'll get a SELECT version that will show what goes in your WHERE clause.