PHP/MYSQL using an array in WHERE clause

Question

given an array

$galleries = array
         (
           [0] => 1
           [1] => 2
           [2] => 5
         )

I want to have a sql query that uses the values of the array in its WHERE clause like:

SELECT *
FROM galleries
WHERE id = //values of array $galleries... eg. (1 || 2 || 5) //

How can I generate this query string to use with mysql?

Answer 1

select id from galleries where id in (1, 2, 5);

Simple for each loop will work.

EDIT: Flavius/AvatarKava's way is better, but make sure that none of the array values contain commas.

Answer 2

 $ids = join(',',$galleries);  
 $sql = "SELECT * FROM galleries WHERE id IN ($ids)";

Answer 3

Assuming you properly sanitize your inputs beforehand...

$matches = implode(',', $galleries);

Then just adjust your query:

SELECT *
FROM galleries
WHERE id IN ( $matches )

Quote values appropriately depending on your dataset.

Answer 4

$matches = implode(',', $galleries);

Does this work ? Doesn't need to be in quotes? Like:

$matches = implode('','', $galleries);

So that $matches can correspond to IN ( 'something', 'something', 'etc' ) in SQL ?

Or the IN statement accepts just the strings separated by commas?

Thank you