Sadly, I'm (re)new at coding. I haven't had to do any coding in years and BOY have things updated.
I need some help with something that doesn't look like it should be as difficult as I'm making it to be.
I have a pretty simple XML file that I need to pull data from and insert into two related tables.
Could someone help me? If I could just get a start on the code, I could write it.
This is the WHOLE file...Of course, the full report would be many more players but here it is.
<?xml version="1.0" encoding="ISO-8859-1"?>
<Tournament Name="2013-10-15-1930-HOL" TournamentStartDate="2013-10-15 19:38:19" TournamentEndDate="2013-10-15 22:47:53" TournamentComments="">
<Players>
<Player FirstName="Joe" LastName="Blow" Rank="35" TournamentPts="20" RoundOut="2" TimeOut="2013-10-15 19:57:51"/>
<Player FirstName="Summer" LastName="Sally" Rank="6" TournamentPts="170" RoundOut="10" TimeOut="2013-10-15 22:31:08"/>
</players>
</Tournament>
Tournament information needs to be pulled out and inserted into a table called, "myevents" and the player rows need to go to a table called, "event_results"
ANY HELP on how I could do this would be GREATLY appreciated. Once I get going, I learn fast. I know I'm making this harder than it needs to be.