How Can I Refresh A Detail Select List When My Master Select Changes Using AJAX

I'm looking for some pointers. I have one select list with a list of topics; ).change(function() { // make AJAX call to update the second select list $.ajax({ url: "path/to/your/action", data: $('#TopicDescription').val(), success: function(data){ // do something to your other dropdown // for example if your getting the data back to fill it with from your post method $('#SubTopicDescription').html(data); // you get the point } }); }); Copy Solution 2: I asked a similar question and it got closed because it was a a duplicate of this apparently. Here is what I asked Using PHP/SQL - How can I click an item in a list to display another list of items assoicated to the clicked item I use a list of links rather than a drop down select. Anyways I got it working with some help. I have 2 tables. the "list" table (which has ID and listName fields) and a "listitems" table (which has id,itemName, and parent fields). When you click a list the items that have that list as a parent are displayed in another list next to it. Here you go. It has deprecated functions and is sloppy but it wil do for now while I learn more. I'm still a beginner but if I get around to cleaning it up I will edit this. <?php require ('./includes/connection.inc.php'); /* AJAX request */ if(!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') { $query = sprintf('SELECT * FROM listitems WHERE parent=%d', mysql_real_escape_string($_REQUEST['parent'])); $listitems = mysql_query($query) or die(mysql_error()); printf('<h3>List %d Items</h3>', $_REQUEST['parent']); while($info = mysql_fetch_array( $listitems )) { echo $info['itemName']."<br />"; } exit; } /* Normal request */ ?> <div id="lists"> <h3>Lists</h3> <?php $lists = mysql_query("SELECT * FROM lists") or die(mysql_error()); while($info = mysql_fetch_array( $lists )) { echo '<a href="?parent='.$info['id'].'">'.$info['listName'].'</a><br />'; } ?> </div> <div id='listitems'> <?php $query = sprintf('SELECT * FROM listitems WHERE parent=%d', mysql_real_escape_string($_REQUEST['parent'])); $listitems = mysql_query($query) or die(mysql_error()); printf('<h3>List %d Items</h3>', $_REQUEST['parent']); while($info = mysql_fetch_array( $listitems )) { echo $info['itemName']."<br />"; } ?> </div> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script> <script>jQuery(function($)){ $('#lists').delegate('a', 'click', function(e){ e.preventDefault(); $('#listitems').load($(this).attr('href')) }); } </script> Copy Share Post a Comment for "How Can I Refresh A Detail Select List When My Master Select Changes Using AJAX" Top Question Div "hiding" When Changing Dropdown Value This is related to a previous question I asked: Hide / Show… Vertically Align Links In Lists I've got the following HTML markup; item 1 i… Same Number Of Fluid Tiles In A Row, No Matter The Screen Width - CSS/jQuery? I need to have 23 square tiles, same width and height, on a… @font-face Behavior Inconsistencies Inside Of @media Query Rules (IE9) The current behavior in Chrome, Firefox and Safari when it … How To Have Images In Line With Text In Css I'm creating the footer of my website using html and cs… Tbody Element Won't Respect Max-height I am just stumped; I have an element that for reasons I can… I Don't Want Pop Up Window To Be Resizable I have a popup window which appears after clicking on a but… Highcharts With Angularjs Drilled Down Does Not Work I am developing a drilled down chart using HichartJS, the c… I Don't Want Pop Up Window To Be Resizable I have a popup window which appears after clicking on a but… Make Text "more" Selectable I have text in a tag: Hello world... and goodbye mind A B!… December 2024 (1) November 2024 (38) October 2024 (58) September 2024 (17) August 2024 (205) July 2024 (192) June 2024 (407) May 2024 (696) April 2024 (421) March 2024 (761) February 2024 (867) January 2024 (784) December 2023 (808) November 2023 (373) October 2023 (620) September 2023 (321) August 2023 (325) July 2023 (269) June 2023 (367) May 2023 (216) April 2023 (149) March 2023 (139) February 2023 (172) January 2023 (255) December 2022 (137) November 2022 (203) October 2022 (175) September 2022 (158) August 2022 (291) July 2022 (98) Menu Halaman Statis Beranda © 2022 - Html5 Guru