3 listbox ajax dropdown with reload(this.form)

cabalsdemon
06:08:12
what i am trying to do is have 3 listbox that reload as you click them

here is the js


function reload(form)
{
var val=form.state.options[form.state.options.selectedIndex].value;
self.location='homes.php?state=' + val;
}
function reload1(form)
{
var val=form.state.options[form.state.options.selectedIndex].value;
var val2=form.county.options[form.county.options.selectedIndex].value;
self.location='homes.php?state=' + val + '&county=' + val2;
}
function reload2(form)
{
var val=form.state.options[form.statet.options.selectedIndex].value;
var val2=form.county.options[form.county.options.selectedIndex].value;
var val3=form.city.options[form.city.options.selectedIndex].value;
self.location='homes.php?state=' + val + '&county=' + val2 + '&city=' + val3;
}


here is the html


<?
include'admin/configs/configs.php';
@$state=$_REQUEST['state'];
@$county=$_REQUEST['county'];
@$city=$_REQUEST['city'];

$quer2=mysql_query("SELECT DISTINCT state,id FROM states");

if($state){
$quer=mysql_query("SELECT DISTINCT * FROM county where state='$state'"); }

$quer3=mysql_query("SELECT DISTINCT * FROM cities where county='$county'");

echo "<form method=post name=f1 action='homes.php?state=$state&county=$county'>";


echo "<select name='state' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while($mbfh2 = mysql_fetch_array($quer2)) {
if($mbfh2['state']==@$state){echo "<option selected value='$mbfh2[state]'>$mbfh2[state]</option>"."<BR>";}
else{echo "<option value='$mbfh2[state]'>$mbfh2[state]</option>";}
}
echo "</select>";

echo "<select name='county' onchange=\"reload1(this.form)\"><option value=''>Select one</option>";
while($mbfh = mysql_fetch_array($quer)) {
if($mbfh['county']==@$county){echo "<option selected value='$mbfh[county]'>$mbfh[county]</option>"."<BR>";}
else{echo "<option value='$mbfh[county]'>$mbfh[county]</option>";}
}
echo "</select>";

echo "<select name='city' onchange=\"reload2(this.form)\"><option value=''>Select one</option>";
while($mbfh3 = mysql_fetch_array($quer3)) {
if($mbfh3['city']==@$city){echo "<option selected value='$mbfh3[city]'>$mbfh3[city]</option>"."<BR>";}
else{echo "<option value='$mbfh3[city]'>$mbfh3[city]</option>";}
}
echo "</select>";

echo "<input type=submit value=Submit>";
echo "</form>";

?>


the first 2 dropdowns reload the last one does not reload
i need the last one to reload please thankz
Please Login to post your reply or start a new topic