如果选择<option>，则再次运行查询[关闭]

Question

I have a dropdown named Category, the options are populated by a PHP script that queries for category names in a MySQL table.

Next to it, I have a dropdown named Subcategory, the options are also populated by a PHP script that queries for subcategory names in a MySQL table.

I'd like to re-run the subcategory query to change the values of the Subcategory dropdown, based on which category has been selected from the Category dropdown.

And I don't want the page to refresh, so I'm thinking jquery might have some use here?

Answer 1

Something like this?

$(document).ready(function(){
    var select = $("#select-element");
    select.change(function(){
        $.ajax({
            type : 'POST',
            url: "url-of-your-php-script",
            data: {
                'data-name' : 'data-to-send'               
            }
            success : function(returned){
               // Append variable  results to select..
            }                
        });            
    });
});​