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

[hakre]

Hi!

WHERE IN your post is the query at all?

you can use the keyword IN for grouping in a WHERE-clause. If you would send the query in, it might be less difficult to help you.

[andreasfriedrich]

Welcome to WebmasterWorld [webmasterworld.com] itspram.

Be sure to read Marcia`s WebmasterWorld Welcome and Guide to the Basics [webmasterworld.com] post.

Have a look at the documentation for Comparison Operators [mysql.com] at mysql.com.

To execute MySQL queries in PHP use the mysql_query [php.net] function.

Andreas

[hakre]

i maybe was a little harsh with my answer. i feel sorry for this. if i would knew more about what was the intention itspram, what he wants to know with a little bit more detail, i'm willing to help.

[jatar_k]

welcome to WebmasterWorld itspram

something like this maybe?

$wherein = "select CategoryID,Categories from table where CategoryID in (1,3,5,7)";
$result = mysql_query($wherein);
while ($items=mysql_fetch_array($result))
{
?>
<OPTION VALUE="<? echo $items['CategoryID']?>"><? echo $items['Categories']?></OPTION>
<?
}
?>
</SELECT>