How to fetch multy records

[eluser]CroNiX[/eluser]
Because when you return result_array(), it's an array, not an object.

Change it to return $query->result() if you want an object.

also, in your view, you will want to loop over $categories

Code:

<?php foreach($categories as $category): ?>
<tr>
  <td class='td-mid'><b>&lt;?php echo $category->title; ?&gt;</b></td>
  <td class='td-mid'>&lt;?php echo $category->description; ?&gt;</td>
  <td class='td-mid'>&lt;?php echo $category->amount; ?&gt;</td>
</tr>
&lt;?php endforeach; ?&gt;