[PHP] mysql select where in php array

Say you are given the following array of ids:

<?php 
 $vals = array
         (
           [0] => 1
           [1] => 2
           [2] => 5
         )
?> 

And you want to run a sql query to retrieve rows where the id is in this array.

<?php 
$ids = join(',' , $vals);  
$sql = "SELECT * FROM galleries WHERE id IN ($ids)"; 
?> 

Posted in: mysql, PHP