NOT IN Statement help plz ?

Anon

Hi all,

in my query I am using a NOT IN statement as follows:

$sql7 = "SELECT id FROM table where (status = '$status1') AND (title like '%$searchstring[$j]%' and id NOT IN('$returned_string')) ORDER BY enddate ASC";

The variable '$returned_string' contains "91,83,73,74,76" and the query only seems to see the "91" so it doesn't return records where the id = 91 but it does for the other numbers in the string ??

I have tried moving the brackets around but that does not do much. Am I expecting this statement to work in a way it is not supposed to or is there a problem, maybe another way to achieve the same result ?

Thanks heaps for any help.

Anon

I should also mention that I have tried using DISTINCT as another way of achieving the same result I want but as I have found out and from reading here there is a bug with that statement and it does nothing.

tomhath

Do you really want your query to read:

id NOT IN('91,83,73,74,76')

It looks like you have an extra set of quotes around the list of ids. My guess is that the dbms converted that string into the number 91 and ignored everything beyond the first comma.

Anon

Thanks for your comment, how do I get the query to select only records with ids that are not contained within a string or a list of ids ?

Am really stuck and don't know how to do this.

thanks

Anon

Oops,

I see exactly what you mean, I removed the quotes and it works !

I should have spotted that. Thanks for pointing that out to me, the smallest things can be overlooked sometimes.

Cheers.