<?php
    $query = $this->db->get('mytable');

    foreach ($query->result() as $row)
    {
            echo $row->title;
    }
?>

bu kodu kullan
ya da

<?php
$query = $this->db->query("SELECT * FROM myTable");

foreach ($query->result_array() as $row)
{
        echo $row['title'];
        echo $row['name'];
        echo $row['body'];
}