[Resolved] Query returns results in phpMyAdmin but doesn't with ActiveRecord

[eluser]codeshadow[/eluser]
Hi,

The problem with your model is the final return statement:

Code:

return $results;

Just replace it with:

Code:

return $results->result_array();

The query is getting executed right now, but you cannot print it as the result has not been passed properly to the controller.
Currently in your code, the content of $results gets printed. However, query results are stored in result_array (Check you output, it contains such a term).

I hope this solves the problem.

Have fun