Help using jquery change event for drop down list

Hello,

I am trying to use a drop down box on my page. When a user selects a category from the list, I want to perform a function (filtering a table). I know the code for my table and the function to filter it is correct - it's selecting an option and running the function that I can't get to work.

I'm currently using this exact same script on another page, only instead of using the .change event, I am using .click because the categories are displayed as links.  In this case, there are so many categories that I want them to be displayed as a drop down box instead, so I was pretty sure that I just needed to change the script to use the .change event, correct? I'm sure its something very simple, but I'm still new to javascript and jquery. Thanks for your help!


drop down box html:
 
<select id="categories">
	<option>Select a Category</option>
	<option id="showAccomodations">Accommodations/Lodging/Travel</option>
	<option id="showAccounting">Accounting/Bookkeeping/Tax Services</option>
	<option id="showAdvertising">Advertising/Promotions</option>
	<option id="showAgricultural">Agricultural Equipment/Sales/Repair</option>
	<option id="showAuto_Truck_Sales">Auto/Truck Sales</option>
</select>
 
 
script:
<script type="text/javascript" src="http://www.mercerbusinessdirectory.com/jquery.dataTables.js">
</script>
<script type="text/javascript" charset="utf-8">
var filterCategory;
$(document).ready(function() {
filterCategory = $('#listings').dataTable( {
"iDefaultSortIndex": 0,
"sDefaultSortDirection": "asc",
"bPaginate": false,
"bLengthChange": false,
"bFilter": true,
"bInfo": false,
"bAutoWidth": false,
"aoData": [{ "sType": "html" },null,null]
} );
$('#listings').hide();
$('#listings_filter').hide();
$('#showAccomodations').change(function () {
	filterCategory.fnFilter( 'Accomodations/Lodging/Travel' );
	$('#listings').show();
	} );
$('#showAccounting').change(function () {
	filterCategory.fnFilter( 'Accounting/Bookkeeping/Tax Services' );
	$('#listings').show();
	} );
$('#showAdvertising').change(function () {
	filterCategory.fnFilter( 'Advertising/Promotions' );
	$('#listings').show();
	} );
$('#showAgricultural').change(function () {
	filterCategory.fnFilter( 'Agricultural Equipment/Sales/Repair' );
	$('#listings').show();
	} );
$('#showAuto_Truck_Sales').change(function () {
	filterCategory.fnFilter( 'Auto/Truck Sales' );
	$('#listings').show();
	} );
} );
</script>

Open in new window

holly_mbdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Albert Van HalenAnalyst developerCommented:
Rather than bind a change function to each of the options in selectbox, you better bind the change event to the selectbox itself.
You can use the val() method to check what the selected value is and thus filter your dataset and display the results accordingly.

Loose the id attribute for each option.
Specify an empty string to the first option in order to determine if the value is equal to ''.
Bind the change event to the selectbox.
<select id="categories">
        <option value="">Select a Category</option>
        <option>Accommodations/Lodging/Travel</option>
        <option>Accounting/Bookkeeping/Tax Services</option>
        <option>Advertising/Promotions</option>
        <option>Agricultural Equipment/Sales/Repair</option>
        <option>Auto/Truck Sales</option>
</select>
 
<script>
$('#categories').change(function () {
        if($(this).val() != '') {
                filterCategory.fnFilter($(this).val());
                $('#listings').show();
        } else
                $('#listings').hide();
        } );
} );
</script>

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
holly_mbdAuthor Commented:
Perfect! That's exactly what I needed and this is much simpler. I just wasn't quite understanding how the .change event worked...thanks for enlightening me!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
jQuery

From novice to tech pro — start learning today.