passing data from a controller to my view

[eluser]TheFuzzy0ne[/eluser]
Welcome to the CodeIgniter community!

$this should be avoided within views if you can. Rather than doing the foreach in the controller, why not do it in the model and have the model format the data exactly how you need it?

Code:

function get_band($id)
{
    $this->db->where('id', $id);
    $result = $this->db->get('bands');
    return $result->result_array();
}

Or you could do something like this in your controller:

Code:

$data['query'] = $this->form_model->get_band($id);
$data['query'] = $data['query']->result_array(); # PHP 4

#OR

$data['query'] = $this->form_model->get_band($id)->result_array(); # PHP 5