[RESOLVED] Select values from db based on array

[zzz]

I have an array in the following format: [17] => 17 [18] => 18 [26] => 26 [27] => 27 and I need to select values from db table where itemID == values in array.

I thought of running a loop and the a query, but it feels awkward...

foreach ($MyArray as $key => $value){

$query ("
			SELECT *
			FROM t1
			WHERE itemID = '".$value."' ");
	echo '...';
}

I'm having a gut feeling it's easier then I think at the moment?.. Overthinking in progress... help!

[laserlight]

First transform the array into a list of values:

$values = "'" . implode("','", $array) . "'";

or if the column is of a numeric type:

$values = implode(',', $array);

Now, you can use it in your SQL statement:

SELECT "columns" FROM "table" WHERE "value" IN ($values)

[zzz]

halloooooooooooo... implode never even crossed my mind...

laserlight, I'll be lightyears behind in my coding without your constant brilliant support....

need a coffee refill. now.