How can I search mysql table with array?

[Anon]

this is what i have come up so far:
but unfortunately it doesn't work
$variable =array(123, 124, 125);
$search = split($variable);
$query = "SELECT * FROM data where code='$search'";
$result = mysql_query($query)
or die("Quary failed");
echo "\t<ul>\n";
while ($row = mysql_fetch_row($result)) {
$KO=$row[0];
$NI=$row[2];
$KI=$row[3];
$HI=$row[25];
echo"$NI $NI $HI<br>";
}

echo "\t</ul>\n";

[Anon]

I think you are tryin to select all codes in the array if that is so you can use

$all_code = Array('123',124','341')l

$search_string = "('" . implode("','",$all_code) . "')";

then
select * from data where code IN " . $search_string . " order by code;

[Anon]

thanks a lot