I have built this page: http://excelwrestling.com/poola.php for an upcoming dual tournament. I have most all of the data being pulled from my mySQL database, with just some sample data in there now.
I am looking to chain the select boxes, so when the user chooses TEAM 1 (at the top), then it will update all of the WRESTLER 1 select boxes with only names from that team. Same thing for team 2.
Another part of this is, is when a person chooses WRESTLER 1 vs WRESTLER 2, I want those two names to fill in the WINNER field, so the user can choose between those two names only.
Anything you can explain to me, or code you could post would be much appreciated.
Thank you!