Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Dynamic Dependent select box

Posted on 2014-03-03
3
Medium Priority
?
1,708 Views
Last Modified: 2014-03-03
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:

<!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>";

  }
?>

Open in new window

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
0
Comment
Question by:jws2bay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
Gary earned 2000 total points
ID: 39901625
$("#Sup_lft").html(data);

should be

$("#Sup_Lft").html(data);

Notice the case
0
 

Author Comment

by:jws2bay
ID: 39901727
Don't you hate that.   I changed the id to Sup_lft and all is good.

Thanks for giving it a quick look.
0
 

Author Closing Comment

by:jws2bay
ID: 39901731
Correct answer and quick
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Progress
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question