[!--quoteo(post=351230:date=Mar 2 2006, 10:26 PM:name=Christopher Robin)--][div class=\'quotetop\']QUOTE(Christopher Robin @ Mar 2 2006, 10:26 PM) [snapback]351230[/snapback][/div][div class=\'quotemain\'][!--quotec--] So basically all you really want, is for someone to be able to select two different types of fruit, and list the members who have those fruits listed in their say.. profile or of what they like. Well all you really have to do is, post each drop down. Say the first drop down is named input1 and the second input2, just do this on the next page or the page the code exists on. $input1=$_POST['input1']; $input2=$_POST['input2']; This will post the information within the drop down. So say you were making an if statment. [code]if ($input1=='Apple') { do something here } elseif ($input1=='Orange') { do something here }[/code] [/quote] Not quite. take a table that looks like this. name | fruit1 |fruit1num |fruit2 |fruit2num James |apple |3 |pear |2 Jim |orange |4 |plum |1 Jill | kiwi |2 |apple |6 I want to be able to create a single dropdown that will list the distinct entries from both colums fruit 1 and fruit 2. As my script is now I can only get one column to list in the dropdown. The end result I am aiming for is to be able to select from a single drop down any fruit name from any number of colums (in this example 2) as users are given the option to list in two different text fields to list any fruit. Then to be able to search for names possessing a fruit from the dropdown and specifiy a range of quantity (represented by the fruit1num amd fruit2num columns) of that fruit and it return a list of who has it. For example in my sample table (if this worked) I would see the following list in the dropdown: apple, pear, orange, plum, kiwi I can then pick a fruit specify a spread of quantity 1-10 and it will return who has it and in what number. for example if I selected: apples in a quantity of 1-5, It would return James 3. but if I selected: apples in a quantity of 3-8, it would return James 3 and Jill 6. maybe this explains better what I am trying to do. my script works but only for 1 column not multiple.