CI MySQL says no results, PHPMyAdmin has results

[eluser]smilie[/eluser]
Hi all,

I have following 'problem'.
I am creating a 'dynamic' query based on the user input (multi select boxes).

Problem is following:
In one case, whereby some options have been selected by user CI says that result is empty.
However, when I print the query in question and paste it to the PHPMyAdmin - I do get results.

So, why does CI does not see these results, while very same query on PHPMyAdmin returns results?

Some code:

Code:

$do = $mydb->query($query);
$result = $do->result_array();

There are no MySQL errors (checked it). But CS simply 'thinks' that result is empty

Thanks!

Cheers,
Smilie