jws2bay
asked on
Dynamic Dependent select box
I'm trying to build a test case of a dynamic dependent select box using mysql/php, ajax, jquery. Should be streight forward but I having problems.
Here is the test page:
Thanks
Here is the test page:
<!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" />
<title>Untitled Document</title>
<script src="http://code.jquery.com/jquery-1.11.0.min.js"></script>
<script src="http://code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#depth").change(function(){
var depth=$("#depth").val();
$.ajax({
type:"post",
url:"support_get.php",
data:"depth="+depth,
success:function(data){
$("#Sup_lft").html(data);
}
});
});
});
</script>
</head>
<body>
Depth :
<select name="depth" id="depth">
<?php
include "support_db.php";
$result=mysql_query("SELECT Category,Series,Glass_Support,Finish,Key_2 FROM Form_Content WHERE Category='Depth' and Series='CRY140-2'");
while($depth=mysql_fetch_array($result)){
echo "<option value=$depth[Key_2]>$depth[Finish]</option>";
} ?>
</select>
Support :
<select name="Sup_lft" id="Sup_Lft">
<option>-select Support-</option>
</select>
</body>
</html>
********************** support_get.php *****************
<?php
include "support_db.php";
$depth=$_POST["depth"];
$result=mysql_query("select Display_Name,Key_3 FROM Products where Pri_Group = 'CRY140' AND Sec_Group='Lft' AND Key_2='$depth'");
while($Sup_lft=mysql_fetch_array($result)){
echo"<option value=$Sup_lft[Key_3]>$Sup_lft[Display_Name]</option>";
}
?>
The include "support_db.php" and mysql/php access seems to be working. I have verified that the mysql data is in place. The first select box is functioning. The Ajax fetch doesn't populate the second select box. I hope someone will be able to easily point out what I have wrong.Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Correct answer and quick
ASKER
Thanks for giving it a quick look.