Newbie confusion about the database docs

[eluser]Colin Williams[/eluser]
Well, when you call a method like, $this->db->where('id', 1), the $db object stores the 'where' information of the query in a property of the $db object. You can access it directly with $this->db->_ar_where I believe. It does similar things with other methods (like(), join(), orderby(), etc). When you call the get() method, the $db object uses the pieces of the query it has previously stored to build the SQL query and executes it. It also clears out the info it previous stored (unless you instruct it otherwise). Just look at the code if you're really curious.