chained combo boxes problem

tayys · 10-21-2011, 09:34 AM

Hi there,

I failed to create the options for the second combo box depend on the selection of the first combo box.

Is there any problem with my jquery there?
$("#cboMain").change(function() {
$("#cboSub").load("getter.php?choice=" + $("#cboMain").val());
});
Any helps are very much appreciate.

codes for index.php:

Code:

<?php
require_once 'connectDB.php';

$id=$_GET['sub_id'];

$sql="SELECT * FROM tb_process";
$result=mysql_query($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="JavaScript">
$("#cboMain").change(function() {
	$("#cboSub").load("getter.php?choice=" + $("#cboMain").val());
});

</script>

</head>
<body>
<form id="form1" name="form1" method="post">
	<select name="cboMain" id="cboMain" class="cboMain">
   		<option value="0" selected="selected">----Select Main Process----</option> 
		<?php 
		while ($row = mysql_fetch_array($result)) 
		{
			$pro_id = $row['pro_id'];
			$pro_name = $row['pro_name'];	
			echo "<option value='$pro_id'>$pro_name</option>";
		}
		?>
	</select>
	<select name="cboSub" id="cboSub" class="cboSub">
   		<option value="0" selected="selected">----Select Sub Process----</option> 
	</select>
</form>

</body>
</html>

codes for getter.php:

Code:

<?php
require_once 'connectDB.php';

$choice = mysql_real_escape_string($_GET['choice']);

$query = "SELECT * FROM tb_sub_process WHERE pro_id='$choice'";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) 
{
	$sub_id = $row['sub_id'];
	$sub_name = $row['sub_name'];	
	$select = ($id == $sub_id) ? 'selected="selected"' : NULL;
	echo "<option value='$sub_id' $select>$sub_name</option>";
}
?>