dynamic drop-down list

chintupintu03

Hi all,

Please find the code, where I have problem. The country selected is to be used for displaying state list. Also when the form is seen, the list of states of default country in the country list box is to be displayed.

Can anybody help me out in ths code? How to update this state list thorugh "onchange" ? Am I going on right track or what is to be changed?

<table border="1" width="740" cellspacing="0" bgcolor="#FFE6D9" align="CENTER" bordercolor="FFD8B0">
<tr>
<td width="200" align="middle" valign="middle" bgcolor="#FFF3EF"

class="text">Country :<br>
</td>

<td width="540" align="middle" bgcolor="#FFF3EF">
<SELECT NAME="country_array" onChange="ChangeNames(this.options.selectedIndex)">
<?php
/ Build the list of countries here, so that it can be displayed in the list-box. /
$query = " SELECT country_id, country_description
FROM country_m
Order by country_description " ;
$country_result = mysql_query($query) or die ("SELECT not proper.");

/ Now, append country_id's below the NULL value. /
while ($list = mysql_fetch_array($country_result))
{
?>
<OPTION value=<?php echo $list[country_id] ; ?> >
<?php echo $list[country_description] ; ?>
</OPTION>
<?php } ?>
</SELECT>
</td>
</tr>
</table>

<table border="1" width="740" cellspacing="0" bgcolor="#FFE6D9" cellpadding="0" align="CENTER" bordercolor="#FFD8B0">
<tr>
<td width="330" align="middle" height="28" valign="middle" bgcolor="#FFF3EF" class="text"> Select State :
</td>

<td width="325" align="middle" valign="middle">
<select multiple name="available_list" size=8 style="width:325;" class="engfont">
<?php
/ Build the list of states here, so that it can be displayed in the list-box. /
$query = "select A.state_id, state_description from states_m WHERE A.country_id = <<country_selected_from_list>> order by state_description ";

$state_result = mysql_query($query) or die ("SELECT for states failed.");

while ($list = mysql_fetch_array($state_result))
{
?>
<OPTION value=<?php echo $list[state_id] ; ?> >
<?php echo ltrim($list[state_description]) ; ?>
</OPTION>
<?php } ?>
</select>
</td> </tr> </table>

tsinka

Hi,

change the javascript block to:

<script language="JavaScript"> 
function ChangeNames(x) 
{ 
current_number_found = x ; 
alert (current_number_found) ; 
} 
</script>

Remove the $ characters, you mixed up PHP and javascript syntax.

Thomas

chintupintu03

The alert in the function is for testing purpose. The actual thing I wanted to do is, using value "x" I want to form the drop-down list in the second field. [ the variable with name "selected_list". The value "X" is to be used for the variable "<<country_selected_from_list>>" in the query.

The bottom line of the problem is, the list to be formed for "selected_list" depends on value picked up from "country list". With the initial value shown in the country list, the list is to be formed for "selected_list"

Please help.

tsinka

Hi,

look at this page http://www.abc-of-travel.com/travelpartners/test10.asp.

There is an example about dynamically building continent/country/states selects.

Thomas

chintupintu03

Please find the following code. I have defined "global" variable in function, to store the value and use in a query for "state list formation". But the does not get passed.

$current_number_found = x ;
alert ($current_number_found) ;
}

</script>

<td width="325" align="middle" valign="middle">
<select multiple name="available_list" size=8 style="width:325;" class="engfont">
<?php
/ Build the list of states here, so that it can be displayed in the list-box. /
$query = "select A.state_id, state_description from states_m WHERE A.country_id = $current_number_found order by state_description ";

$state_result = mysql_query($query) or die ("SELECT for states failed.");