searching through multiple select value

[Anon]

hello!!
i would like to know how to interlink three or more dropdowns on the form to allow the user to search on either criterias....like ive fields product , quality and origin..user can search on either basis..or any combination of two and even with all three.....

i would appreciate your suggetions soon....thanku

[stuartc1]

Show the three select boxes in the html page and give an option Please Select the value of 0 or none.

On the PHP page create a statement like this:

$where = "WHERE 1=1 ";
if (selectone !== "none") {

$where .= "AND option1 = $selectone";
}
// the same for the other two.

$qry = "SELECT whatever FROM whatever $where";

get the idea ??