mysql SELECT FROM WHERE IN question

[derksj]

can someone tell me why this script is not working

$tekenreeks = implode(",", $ID);

$result = ("SELECT Faciliteit FROM tblFaciliteiten WHERE FaciliteitenID in ($tekenreeks)");

while ($myrow = mysql_fetch_array($result))
{
echo $myrow ["Faciliteit"];
}

[kamy99]

It seems you have a mistake in your SQL statement:

WHERE FaciliteitenID in ($tekenreeks)

shoud be:

WHERE FaciliteitenID ='$tekenreeks)'

HTH

[Lars_Berg]

You never calls mysql_query.