where = $array

[edeltatc2]

Is there a way to construct a query that will search the values in an array.

I.E.

$array1 = array(10, 45, 56, 32);

$query = "SELECT name FROM users WHERE id = '$array1''";

But instead of matching the entire array. I want it to match one (or more) of the array values.

[zonewatcher]

What about ...

$array1 = array(10, 45, 56, 32); 

$comma_separated = implode(",", $array1);

$query = "SELECT name FROM users WHERE id in ($comma_separated)";

[edeltatc2]

I was trying to make harder than it is

Thank you