[eluser]bwuk[/eluser]
Hi,
I have a DB query that returns over 50000 results from the DB.
If we assume that my function and query looks like
Code:
function get_all_rec()
{
$this->db->select('*');
$this->db->from('my_table');
$qUsers = $this->db->get();
return $qUsers
}
and then in another method in the class, I have:
Code:
$qUsers = $this->get_all_rec();
I can then output:
Code:
echo 'num_rows(): '.$qUsers->num_rows().'<br />';
but when I try and get:
Code:
echo 'first row, user id: '.$qUsers->row(0)->user_id.'<br />';
codeigniter/php doesn't return anything. The whole script terminates and I don't know why.
Has anyone else had this issue with CI?
Thanks
bwuk