Cross-referencing XML documents
Hi, so I'm rather new at XML. I've coded in php and mysql before, but now I'm trying to learn AJAX, more specifically using XML to store and change data based on the enduser's selections from option and checkbox lists. Anyways, the problem I've come across is before any of that starts.
To give you specifics, I'm creating a webpage for my fantasy NHL league to select players from their previous teams that they would like to keep on their rosters. There are some restrictions on which players they can keep, so I need to be able to reference between a player's information (things like age, what round he was selected, and previous season stats) and the league member's roster. I feel right now as though there are two ways I can do this.
My first option would be to create an XML document of NHL players with all their information. This would require parsing through the entire player database to call on each league member's roster and keeper options.
My second option is a bit fuzzy to me right now, but it would basically be creating a document with each league member's roster, then create seperate documents full of all players who are allowed to be kept under each restriction. Then cross-reference the document containing member's roster with the one containing players they're allowed to keep and display only the players found in both documents (simply put, display players on the logged-in member's roster who appears on the list of keepers). Is that possible?