This should be simple..

[merveilles]

This is probably really simple.. I have a php array, and right now I'm using foreach to get each item, and look it up in a database. So like...

 

foreach($list as $item){

mysql_query("select id where random = '$item'");

}

 

It seems inefficient to do that if there are like 100 items in the array.. Is there a way I can get each specific id for each item using only one mysql query?

[trq]

$sql = "SELECT id FROM tbl WHERE random IN(" . implode(',', $list) . ")";