code in the controller:
$this->load->database();
$query = $this->db->get('table');
return $query->result();
code in the view file:
<?php foreach ($query->result() as $row): ?>
<li><?=$row->id?></li>
<?php endforeach; ?>
error I get:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: query
Filename: articulos/gestion_view.php
Line Number: 9
Fatal error: Call to a member function result() on a non-object in /Users/alejandro/Dropbox/webserver/codigniter/application/views/articulos/gestion_view.php on line 9