Fatal error: Call to undefined method CI_Loader::result()

[eluser]Jamie Rumbelow[/eluser]
Hello Rick,

Firstly, welcome to the CodeIgniter community!

You're trying to call result() on the CI master object - which is definitely not a good idea. result() is a method given to you by the DB result object, which is returned by $this->db->get() or $this->db->query(). In your controller, you assigned the result object to $data['query'], so in the view it's available as $query.

Knowing this, we just have to change the foreach loop in your view and it all should work:

Code:

<?php foreach($query->result() as $row): ?>

When in doubt, read the user manual - it's very comprehensive. Hope this has helped.

Jamie