How Can I Refresh A Detail Select List When My Master Select Changes Using Ajax March 31, 2024 Post a Comment 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 } }); }); CopySolution 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.<?phprequire ('./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) ordie(mysql_error()); printf('<h3>List %d Items</h3>', $_REQUEST['parent']); while($info = mysql_fetch_array( $listitems )) { echo$info['itemName']."<br />"; } exit; } /* Normal request */?><divid="lists"><h3>Lists</h3><?php$lists = mysql_query("SELECT * FROM lists") ordie(mysql_error()); while($info = mysql_fetch_array( $lists )) { echo'<a href="?parent='.$info['id'].'">'.$info['listName'].'</a><br />'; } ?></div><divid='listitems'><?php$query = sprintf('SELECT * FROM listitems WHERE parent=%d', mysql_real_escape_string($_REQUEST['parent'])); $listitems = mysql_query($query) ordie(mysql_error()); printf('<h3>List %d Items</h3>', $_REQUEST['parent']); while($info = mysql_fetch_array( $listitems )) { echo$info['itemName']."<br />"; } ?></div><scriptsrc="//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 Input Type Datetime-local Is Not Working In Firefox I have an input type of datetime-local which is working fin… Can I Absolutely Position An Element In The Top Right Corner Of A Element? I have a table and I need the cells to have an element posi… CSS - Auto Fill Height Here's a js fiddle of what I currently have, I am tryin… Store A Generated Random Number In A Variable, Then Call That Variable As A Filename To Bring Up An Image. Javascript So I have a few pictures that I want to randomly generate o… CSS Hover Jitter Issue This is my first question. I usually try to research these … Right Floated Element Disappears When Using Columns In Firefox I am using an ol element with column-count and column-gap p… Setting Link Href From Child Image Src Using JQuery I am using .wrap() to create a link around each image withi… How To Limit The Html Table Records In Each Page I am populating a table in my jsp which has more than 20 re… Separate Countdown For Divs I want to show countdown in each of my divs. Right now I ge… Retain Dynamically Created DropDown List's Selected Value On Event Window.history.back()- JavaScript Can use the below question as a reference to explain the co… December 2024 (1) November 2024 (38) October 2024 (60) September 2024 (20) August 2024 (360) July 2024 (336) June 2024 (693) May 2024 (1285) April 2024 (802) March 2024 (1568) February 2024 (1697) January 2024 (1377) December 2023 (1447) November 2023 (380) October 2023 (599) September 2023 (335) August 2023 (347) July 2023 (287) June 2023 (341) May 2023 (234) April 2023 (140) March 2023 (130) February 2023 (178) January 2023 (281) December 2022 (110) November 2022 (237) October 2022 (815) September 2022 (159) August 2022 (296) July 2022 (96) Menu Halaman Statis Beranda © 2022 - Html5 World