query value dd menu via javascript

[Anon]

Hi..
This is my dd menu.
<select name="semester" size="1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>

1. Let say user select 1.
2. Query the database based on selected value.
   $query = "SELECT * FROM semester WHERE semester = '1'"
3. Then it will display a result/list that match with the query without submit the page.

Can this be done and how??

[nostradamus]

Put the following Java script in your html-head :

<script type="text/javascript">
<!--
function Go(x)
{
if(x == "nothing")
{
document.forms[0].reset();
document.forms[0].elements[0].blur();
return;
}
else
{
top.content.location.href = x;
document.forms[0].reset();
document.forms[0].elements[0].blur();
}
}
//-->
</script>

and then use it like the following :

<form name="MetaForm2"><select size="1" name="MetaAusw2" onChange="Go(this.form.MetaAusw2.options[this.form.MetaAusw2.options.selectedIndex].value)">
<option value="nothing">please choose</option>
<option value="yoursite.php?var=1">1</option>
<option value="yoursite.php?var=2">2</option>
<option value="yoursite.php?var=3">3</option>
</select></form>

You don´t need to submit the form. On change of the combobox it jumps to the next site.