[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