newbie active record question: show me the SQL!

[eluser]Unknown[/eluser]
or ...

Code:

$this->db->last_query();

Returns the last query that was run (the query string, not the result). Example:

Code:

$str = $this->db->last_query();

Code:

echo $str;

// Produces: SELECT * FROM sometable....

ripped from the user_guide