Go Back   CodingForums.com > :: Client side development > JavaScript programming > Ajax and Design

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 06-09-2012, 01:16 AM   PM User | #1
cabalsdemon
New to the CF scene

 
Join Date: Feb 2011
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
cabalsdemon is an unknown quantity at this point
3 listbox ajax dropdown with reload(this.form)

what i am trying to do is have 3 listbox that reload as you click them

here is the js

Code:
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
PHP Code:
<?
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 buttons reload the last one does not reload
i need the last one to reload please thankz
cabalsdemon is offline   Reply With Quote
Old 06-09-2012, 01:55 AM   PM User | #2
cabalsdemon
New to the CF scene

 
Join Date: Feb 2011
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
cabalsdemon is an unknown quantity at this point
i meant the first 2 dropdowns reload the last one does not reload
i need the last one to reload please thankz
cabalsdemon is offline   Reply With Quote
Old 06-13-2012, 11:21 AM   PM User | #3
cabalsdemon
New to the CF scene

 
Join Date: Feb 2011
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
cabalsdemon is an unknown quantity at this point
nm i found what i did wrong
had an xtra t in state
Quote:
var val=form.state.options[form.statet.options.selectedIndex].value;
cabalsdemon is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 04:14 PM.


Advertisement
Log in to turn off these ads.