[RESOLVED] NOT IN problem

[bailo81]

I have an array with items in it. I want to select items that are not in this array from a database...

First i imploded it

$items = implode(', ',$items_array);				

Then I have my query...

$sql_display="SELECT * FROM `$table_available`".
		" WHERE `quotas_catid` NOT IN ('$available_products')".
		" AND `userid` = '$username'".
		" LIMIT 2";

but it is still bringing up results in the $items_array :bemused:

[Lars_Berg]

 NOT IN ($available_products)". 

Do echo on the $sql_display variable to check that the statement looks correct.

[bailo81]

Sorted it now, i was just being stupid 😃