Newbie confusion about the database docs

[eluser]xwero[/eluser]
It's one statement. get, get_where, count_all_results, count_all, insert, update, delete, empty_table and truncate are the action methods. They execute the query, all other methods help to build the sql statement.

Code:

$query = $this->db->select('title')->from('mytable')->where('id', $id)->limit(10, 20)->get();

Internally those other methods store their parameters until an appropriate action method reads the data and empties the storage variables.