[DrBurkstrom]

I have a mysql table where the items all have an id field (obviously), and I want to select only those items whose id is contained in a php array.

Is this possible without iterating through the array and pulling each item out individually with it's own query?

Thanks

[RaelRode]

Just callt he one field "id" and put it in a loop. Not sure how to do this anymore but someone else may give a code example.

[gk]

PHP Code:

$rs=mysql_query('SELECT * FROM table_name WHERE id IN (0,1,2,3,10)');
while($row=mysql_fetch_assoc($rs)){
//do stuff
echo "At row $id<br />\n";
} 


The where will cause the statement to only select rows with ids of 0,1,2,3 and 10 rows 4,5,6,7,8 and 9 are all skipped.

[DrBurkstrom]

Hah - So simple yet it's been completely eluding me! Thanks gk, that's just what I need!

[RaelRode]

See theres your loop!!!!!!!!!!