Very Easy NOT IN $list Question

bink

I am getting an error when using the following code:

$id_array = array('4', '6', '10', '12', '13');

$result = mysql_query("SELECT course_id FROM primary_courses WHERE course_id NOT IN ($id_array)");

It returns an invalid result resource and I am sure its something to do with the NOT IN ($id_array)

I must have some syntax or something wrong.

When I use NOT IN ('$id_array') I dont get an error but then it just selects everything from the database and seems to disregard the list totally.

Help me out please!

thanks,
Kevin

HalfaBee

If you echo out the sql you will see what is going wrong.

A debug in time saves nine posts 🙂

HalfaBee

bink

SELECT course_id FROM primary_courses WHERE course_id NOT IN (Array) AND csc=1 LIMIT 50

That is what I get when I echo the SQL. Now I know what the problem is but I still have no idea how to fix it. =)

Thanks,
Kevin

tekky

maybe replace $array_var with

explode(", ", $array_var)

winterbeef

Tekky I think you got it backwards; I believe bink wants to 'join()' not 'explode()':

$sql = "SELECT course_id FROM primary_courses WHERE course_id NOT IN (".join(",",$id_array).")";

HTH

tekky

Originally posted by winterbeef
Tekky I think you got it backwards; I believe bink wants to 'join()' not 'explode()':
$sql = "SELECT course_id FROM primary_courses WHERE course_id NOT IN (".join(",",$id_array).")"; 
HTH [/B]

err woops yes, implode(", ", $id_array);