CI MySQL says no results, PHPMyAdmin has results

CI MySQL says no results, PHPMyAdmin has results

El Forum
Guest

10-20-2010, 05:28 AM

[eluser]smilie[/eluser]
Oke, I have narrowed problem to this line (I think):

Code:
$query .= " AND something IS NOT NULL AND something != ''";

Whereby the idea is to select from database where field 'something' is either empty or NULL.

But, only when this line is added to the query, CI says: no results; but PHPMyAdmin finds 31 rows that match the query Sad

Cheers,
Smilie

Messages In This Thread

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:20 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:27 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:28 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:31 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:35 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:43 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:57 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 05:59 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 07:24 AM

CI MySQL says no results, PHPMyAdmin has results - by El Forum - 10-20-2010, 07:34 AM