seabee1982 Posted January 22, 2013 Share Posted January 22, 2013 (edited) I have seen numerous topics outlining cascading multiple dropdown boxes, however, I'm having trouble coming up with a solution to a similar, but different, problem. I'm trying to come up with a better way for a selection of a visitor's best 5 vacation states. Without a chance of duplicate selections. I see 2 ways to handle this: 1. Use php/html to populate the dropdowns from the MySQL db table 'states' (5 times). Currently the way I have it set up. 2. Use AJAX to remove the selections in the previous dropdowns (preferred). This eliminates duplicate selections. The first dropdown would populate from a MySQL db table 'states'. The second dropdown would populate from the db and eliminate the first selection. The third dropdown would popluate from the db and eliminated the first and second selections. And so on..... The problem is that the second dropdown is dependent on the selection of the first dropdown. Has anyone come across a "Top 10" list that works the same way? Or should I just verify selections in #1 against each other to prevent duplicate selections? Edited January 22, 2013 by seabee1982 Quote Link to comment https://forums.phpfreaks.com/topic/273504-multiple-dropdown-boxes/ Share on other sites More sharing options...
Barand Posted January 28, 2013 Share Posted January 28, 2013 Option 3. Build a JS array from the database when you create the page then as option 2 without the AJAX, just JS Quote Link to comment https://forums.phpfreaks.com/topic/273504-multiple-dropdown-boxes/#findComment-1408817 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.