I use those function to get the database result. I want to save all "select", "where"... etc query and load this for other function to use
$this->select('title, content, date');
$this->db->where('name', $name);
// Save the query here...
// Do other query
$this->db->select('name');
$query = $this->db->get('other_table');
// Load the query from the save point here
$query2 = $this->db->get('mytable');