How To Use Multiple Select Drop Down

[aashcool198]

HI..

 

my form has one multiple select dropdown box which gives me selected values in an array.

I want to know how can i write mysql query so that i get all the results in which any of the selected case is possible.

 

for example if my array is arr[] than i want to write

 

$result = mysql_query("select * from student where name=arr[0] or name= arr[1] or name=arr[2]....so on....");

 

I don't know how many elements are there in the array hence can't write it directly.. how can i do it?

[cags]

A simple method...

 

$sql = "SELECT * FROM student WHERE name='" implode("' or name='", $arr) . "'";

 

Note: You should filter $arr first for dangerous content using an in_array whitelist.

 

[aashcool198]

You simply cracked it!    thanks a lot!