[SOLVED] An array in the where clause - possible?

[khunjack]

Hi,

 

I'll have a session array with growing numbers of id's.

 

array = (2222,4444,32323,...}

 

The records with these id's need to be excluded ... e..  ' .... id!=2222 and id!= 4444 '

 

Sure could build this querey via a loop.

 

Question: Is there a better/shorter way in the WHERE Clause ???

 

??? WHERE id!={array} ... ???

 

Thanks for every feedback

Jack

[Barand]

<?php
$array = (2222,4444,32323)

$values = join (',', $array);

$sql = "SELECT * FROM tablename WHERE id NOT IN ($values)";

[khunjack]

Barand,

 

fantastic!!!

 

Thank you very much for your straight forward solution .. big time appreciated.

Jack

[fenway]

Just remember this prevents the use of any index.