View providing no results, but table has recent entries

[eluser]Chad Fulton[/eluser]
Okay, this has been a long process just to find out there was no MySQL error!

It turns out, I should have just taken a look at the code. Although, I have to say that I find it a bit suspicious that this supposedly used to work?

In your controller, you have:

Code:

$data2 = array('payouts'=>$this->mdlUser->GetPaymentRequests());

and in your model you have

Code:

return $query->result_array();

and in your view you have

Code:

<?=$payouts->num_rows?>
// ...
var_dump ($payouts->result_array);
// ...
if($payouts->num_rows != 0):
// ...
foreach($payouts->result as $row):
// ...

Notice the problem here?
You're returning an array of results from your model, but in the view you're acting like you've got a query object (although, not really even that, since they ought to be function calls (i.e. $payouts->result_array())

Does this make sense? Here's how to fix it...

In your model:

Code:

return $query;

And in your view, fix all of the things that ought to be function calls (num_rows(), result(), result_array(), etc)

That should do it!