How to make All the query results from model page to controller page?

[eluser]Rocky Mehta[/eluser]
Model Page

Code:

function gelall()
{
$this->load->database();
$query = $this->db->query("SELECT * From overview_facility");
$query1 = $this->db->query("SELECT * From overview_category");
$query2 = $this->db->query("SELECT * From overview_purpose");
return $query->result();
}

controller page

Code:

function index()
{
$this->load->model('provider/overview_model');
$data = $this->overview_model->general();
$data['query'] = $this->overview_model->getall();
$data['query1'] = $this->overview_model->getall();
$data['query2'] = $this->overview_model->getall();

$this->load->view('provider/overview_view',$data);
}

On the view page i have get only $query result, but i got all the result of $query, $query1 and $query2 results on the view page. How can i fetch all the results.

[eluser]Rocky Mehta[/eluser]
Can Anybody help me please????

[eluser]aquary[/eluser]
Separate each query into different functions. There is no meaning to group unrelated scripts together like the way you did.

[eluser]ludo31[/eluser]
try also with

foreach($query->result_array()as $row)
{
$data[] = $row;
}

return $data;
}

[eluser]aquary[/eluser]
I don't know why people love to do foreach to put data in an array, when the result() and result_array() already return an array.... They could just return $query->result() or $query->result_array() directly.