Multiple Populated Combo Boxs

Anon

Ok I have 3 combo boxs.. i have them populated with data from the database. But the thing i cant work out how to do is have the second combo box's populataion be based apon the first's and the 3rds based apon the 2nd's.

To Explain this better the 3 combo boxs are
Region, City, Suburb

Region - cmbox 1
City - cmbox 2
Suburb - cmbox 3

The names the items are displayed in the combo boxes.

Basically this is a user interface form that i am creating. the user selects the region he/she wants to then select a city from. Once a Region is selcted i want the City combo box to only be populated by citys that match the RegionID field of the Region Combo box item. So instead of listing like 100 citys it will only list the 5 cities that are relevant to that regieon. I also want once a city is selcted to have the suburbs only relevant to CityID

I have some java code that sorta does this.. just i dont know how to change the java code so that it is populated witha php variant... still waiting on that article 2 on php and java 🙂....

so if anyone can help me on this would be great. If yah want more info like my actual code ect i can easily provide it. I am hoping that my description is good enough so that you can understand what i am trying to do.

Anon

Im assuming that you mean javascript code, and not java code...big difference...🙂 you can do this javascript--there will be groups of arrays(most likely) that populate the dropdown boxes, which you can fill with PHP driven info. If you post the precise code, I can show you exactly where...or if you go somewhere like javascript.internet.com, they have lots of scripts that do this.

Hope this helps
Darren

Anon

<?php

session_start();
include "/var/www/php/dbhelper.inc";
$db_link_id = openDatabase("i4info_simple");

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Company details form</title>

</SCRIPT>
</head>
<body>
<FORM name="form1">
<table width="670" border="1">
<tr>
<td width="172"><b><font size="5">Company details</font></b></td>
<td width="284" colspan="2"> </td>
</tr>
<tr>
<td width="172">Company name</td>
<td width="284" colspan="2"><input type="text" name="ComName" size="20"></td>
</tr>
<tr>
<td width="172">Company brand name</td>
<td width="284" colspan="2"><input type="text" name="ComBrandName" size="20"></td>
</tr>
<tr>
<td width="172"><b><font size="4">Head office</font></b></td>
<td width="284" colspan="2"> </td>
</tr>
<tr>
<td width="172">Telephone</td>
<td width="284" colspan="2"><input type="text" name="Telephone" size="20"></td>
</tr>
<tr>
<td width="172">Fax number</td>
<td width="284" colspan="2"><input type="text" name="Tax" size="20"></td>
</tr>
<tr>
<td width="172">Email</td>
<td width="284" colspan="2"><input type="text" name="Email" size="20"></td>
</tr>
<tr>
<td width="172">Web address</td>
<td width="284" colspan="2"><input type="text" name="WebAddress" size="20"></td>
</tr>
<tr>
<td width="172"><b>Address</b></td>
<td width="284" colspan="2"> </td>
</tr>

<tr>
<td width="172">Region</td>
<td width="284" colspan="2">
<?php
//Pull data from the database for drop down menu
$table_name="Region";
$query = "SELECT * FROM $table_name ORDER BY 'Name' ASC";
$result = mysql_query ($query,$db_link_id);

echo "<SELECT size='1' NAME = 'form_page2[$table_name]'>\n";

$total_num_rows=mysql_num_rows($result);
if($total_num_rows!=0){
  for ($counter=0; $counter<$total_num_rows; $counter++){
		$current_row = mysql_fetch_row($result);
  	  echo "<option value='$current_row[0]'";
			echo ">$current_row[1] </option>\n";
	}

}else{
$error_msg="No records found";
echo "<option> $error_msg </option>\n";
}
echo "</SELECT>";
?>
</td>
</tr>

<tr>
<td width="172">City</td>
<td width="284" colspan="2">
<?php
//Pull data from the database for drop down menu

$table_name="City";
$query = "SELECT * FROM $table_name ORDER BY 'Name' ASC";
$result = mysql_query ($query,$db_link_id);

echo "<SELECT size='1' NAME = 'form_page2[$table_name]'>\n";

$total_num_rows=mysql_num_rows($result);
if($total_num_rows!=0){
  for ($counter=0; $counter<$total_num_rows; $counter++){
		$current_row = mysql_fetch_row($result);
  	  echo "<option value='$current_row[0]'";
			echo ">$current_row[1] </option>\n";
	}

}else{
$error_msg="No records found";
echo "<option> $error_msg </option>\n";
}
echo "</SELECT>";
?>
</td>
</tr>
<tr>
<td width="172">Suburb</td>
<td width="284" colspan="2">
<?php getDropDown($db_link_id, "Suburb");?>
</td>
</tr>
<tr>
<td width="172">Street, house number</td>
<td width="284" colspan="2"><input type="text" name="StreetHouseNum" size="20"></td>
</tr>

<tr>
<td width="172"><b>Postal address</b></td>
<td width="284" colspan="2"> </td>
</tr>

<tr>
<td width="172"><input type="checkbox" name="C1" value="ON">same as above</td>
<td width="284" colspan="2"><textarea rows="2" name="PostCheckBox" cols="20"></textarea></td>
</tr>

<tr>
<td width="172">Contact person</td>
<td colspan="2">
<form action="./contact_person_new.html">
<input type="submit" value="Contact person" name="B1"></form>
</td>

</tr>

<tr>
<td width="172">Branch</td>
<td colspan="2">
<form action="./branch_list_y.html">
<input type="submit" value="Branch" name="B1"></form>
</td>

</tr>
<tr>
<td width="172"> </td>
<td colspan="2">
 
</td>

</tr>

<tr>

<td>
  <form method="POST" action="--WEBBOT-SELF--">
    <p><input type="submit" value="Back" name="B1"></p>
  </form>
</td>


<td>
  <form method="POST" action="--WEBBOT-SELF--">
    <p><input type="submit" value="Cancel" name="B1"></p>
  </form>
</td>
<td>
  <form action="./page3.html">
    <input type="submit" value="Next" name="B1">
  </form>
</td>

</tr>

</table>

</FORM>
</body>

that is the code....
any help would be apreciated

Anon

xxxx

Anon

So....how do you resolv the problem with 3 combo box?
I have same problem with you
10x
Doru