php concatenate drop down menus

mattiedog

Hi and thanks in advanced.

We would lke to have two drop down boxes on a search page. for example one drop down will contain light bulb wattages( ie 40, 50, 60) and the other drop down will contain type of bulb ( round, oval, twisty etc.). These drop down boxes would be hard coded. no need to change them.

Now my question? how would we concantenate the two drop down boxes. ie. if someone chooses "50" and "twisty" the result would be one field that would contain "50 twisty". how do we do this. Then we need to use this new field to search the database and extract all the prodcuts that meet the criteria.

Thanks

harmor

<select name='type'>
<option value='twisty'>Twisty</option>
</select>

$getbulb = mysql_query("SELECT * FROM bulbs WHERE watts = '$_POST['watts']."' && type='".$_POST['type']."'  ");
$bulb = mysql_fetch_array($getbulb);

I just gave you a rough idea. Hopefully you can alter it so it'll work for you.

suomynonA

Or, you could use a bit of JavaScript to concatenate the fields, then pass the resulted string into the url (or what else idea you might have). A brief example would be:

<html>
<head>

<script type="text/javascript">
function message()
{
var s;
s=document.form1.shapes.value.concat(" ");
s=s.concat(document.form1.watts.value);
alert(s);
}
</script>

</head>

<body>

<form name="form1">

<select name="shapes">
<option value="oval">Oval
<option value="twisty">Twisty
<option value="round">Round
</select>

<select name="watts">
<option value="40">40
<option value="50">50
<option value="60">60
</select>

<input type="submit" onclick="message()">
</form>

</body>
</html>

mattiedog

The two drop down boxes need to be concatenated because the text string that we are looking for is located in a description field of the product. The wattage and the type are not separate tables.

We are willing to pay a developer.

steve
steve@klicktwice.com
561-333-8667

harmor

$getbulb = mysql_query("SELECT * FROM bulbs WHERE description LIKE '%".$_POST['watts']."%' && description LIKE '%".$_POST['type']."%'  ");
$bulb = mysql_fetch_array($getbulb);

I'm not sure if this will work but you can give it a go.