CI MySQL says no results, PHPMyAdmin has results

[eluser]smilie[/eluser]
Hi,

For as I know:

Code:

$query = $this->db->query($query);
$result = $query->result_array();
echo $this->db->last_query();

is same as what I am doing:

Code:

$mydb = $this->load->database('db',TRUE);
$do = $mydb->query($query);
$result = $do->result_array();
echo "last q: "; $mydb->last_query();

But it does not work. Not even when CI does get results back

Cheers,
Smilie