Using an array in MySQL where id IN ($array)?

[extrovertive]

I have an array - $zips = array('92120', '92127')

$zips actually contain a hundred more is generated dynamically.

Now, can I use this kind of SQL?

SELECT username, zip FROM usertable
WHERE zip IN ('$zips')

I tried but it doesn't work. Basically, $zips is an array that contain a lot of zip codes from a class I'm using. However, I can't use an array in a "IN" statement for MySQL?

[hvle]

no you can, you have to separate all zipcodes into a string:
SELECT username, zip FROM usertable WHERE zip IN ('92120', '92127');

it's easy to write a snippet of code to convert your array into a string like that.

[akabugeyes]

How about trying FIND_IN_SET?

SELECT username, zip FROM usertable
WHERE FIND_IN_SET (zip,'$zips');

[Joe Haley]

http://ca3.php.net/implode

implode(); is your friend.

[extrovertive]

I'm trying implode:


$zips = array('92120', '92127');
$zips = implode(',',$zips);
SELECT username, zip FROM usertable WHERE zip IN ($zips);

yields no result, yet just using WHERE zip IN ('92120', '92127') does. I have also implode it using '', ',' but still doesnt' work. FIND_IN_SET give the same result.

[extrovertive]

Ah, here's the solution.
$zips = array(92102, 92127, 92103);
$quoted_zips= array();
foreach ($zips AS $v)
{
    $quoted_zips[]= "'{$v}'";
}
$zip_list= implode(',', $quoted_zips);

SELECT username, zip FROM usertable
WHERE zip IN ($zips)