Database joins, views, etc.

[eluser]Michael Wales[/eluser]

Code:

function test2()
  {
    $third_query = $this->uri->segment(3);
    $query = $this->db
              ->select('*')
              ->from('islands')
              ->join('hotels', 'hotels.island_id = islands.id')
              ->where('hotels.id', $third_query)
              ->limit(1)
              ->get();
    if ($query->num_rows() == 1) {
      $this->data->hotel = $query->row();
    }
    $this->load->view('test2_view', $this->data); // am I passing enough info?
  }