CI and InnoDB returning zero rows?

[eluser]bhogg[/eluser]
Hi all,

A bit of a frustrating problem. I'm running a simple query using active record, with a couple tables joined. The resulting query is valid (I've added an echo in DB_active_rec.php) but num_rows() or $res = $query->result_array(); count($res) both return zero. I then copy the echoed query into phpMyAdmin and I get one row returned.

My thought is it's InnoDB related, since it's my understanding that to get accurate count you need to loop through the results first.

Any ideas?

Brian

[eluser]bhogg[/eluser]
My apologies, it appears it was a logic error, and a slight bought of exhaustion. We've all been there, right?