mySQL Where In function

[itspram]

Hi Experts,

Can anybody tell me how to use
mySQL WHERE IN function in PHP


// this is HTML code
<select size="6" name="Categories[]" multiple>
<option value="0" selected>[ -- Select Categories --]
<?
while ($items=mysql_fetch_array($result))
{
?>
<OPTION VALUE="<? echo $items['CategoryID']?>"><? echo $items['Categories'] ?></OPTION>
<?
}
?>
</SELECT>


///what will be a query using IN function of mySQL
Thanks in Advance

[Elena Mitovska]

WHERE IN expression of MYSQL is used in queries: so use this expressione in query that you use to create variable $result,
for example,

$result=mysql_query("Select CategoryID, Categories from my_table where CategoryID IN (..,..,..,...) ");


Write, please, if I understood your problem correctly.

[itspram]

Exactly,

You have understood it but instead of (..,..,..,..,)
I want to pass variable called from HTML form.

Thanks