Outputting results from Array?

[eluser]invision[/eluser]
Hi,

I'm a little stuck. I would love some help with this.

I want to output the results of a SQL Query into a View.

How do I do this?


model

Code:

function get_entries($country = FALSE, $city = FALSE, $category = FALSE) {

    $this->db->select('entry.*, city.title as city_title, country.iso3 as country_title, category.title as category_title');
    $this->db->from('entry');
    $this->db->join('category', 'entry.category_id = category.id');
    $this->db->join('city', 'entry.city = city.id');
    $this->db->join('country', 'city.country = country.iso3');
    if($country !== FALSE) {
      $this->db->where('country.iso3', $country);
    }
    if($city!== FALSE) {
      $this->db->where('city.title', $city);
    }
    if($category!== FALSE) {
      $this->db->where('entry.aslug', $category);
    }
    $result = $this->db->get();
    if($result->num_rows() > 0) {
      return $result->result_array();
    } else {
      return FALSE;
    }
  }

controller

Code:

if (!empty($param_3)) {
      $data['title'] = $param_3;
      $data['body'] = 'Info about Accommodation';  
        $data['entries'] = $this->Mains->get_entries($param_1, $param_2, $param_3);
        $data['entries2'] = $this->Mains->get_all_cities();
        $data['main'] = 'public_entry';  
     }

view

Code:

<h2>&lt;?php echo $entries['atitle']; ?&gt;</h2>

I know for certain that my SQL Query is working.

Can anyone explain what I am doing wrong?



Many thanks for your time and help.