i am trying to make a script that gets feeds from an third party site and i need to parse the information and add it to a database on my site for user interaction.
i would like some help in the form of you telling me where to read on how to do this, or an example.
i would need to break all the info down, and store it into the database once daily, and this seems like it should be really easy once you break down the xml file into variables.
any help would be greatly appreciated.
here is a sample xml
[CODE]<odds>
−
<entry>
<date_time>05-18-09 7:05 PM</date_time>
<awayrotationnumber>301</awayrotationnumber>
<awayteam>Pirates (Pittsburgh)</awayteam>
<awaymoney>-110</awaymoney>
<awayline>off</awayline>
<awaytotal>o10(-105)</awaytotal>
<homerotationnumber>302</homerotationnumber>
<hometeam>Nationals (Washington)</hometeam>
<homemoney>-110</homemoney>
<homeline>off</homeline>
<hometotal>u10(-115)
</hometotal>
</entry>
−
<entry>
<date_time>05-18-09 7:10 PM</date_time>
<awayrotationnumber>303</awayrotationnumber>
<awayteam>Diamondbacks (Arizona)</awayteam>
<awaymoney>-130</awaymoney>
<awayline>off</awayline>
<awaytotal>o8.5(Even)</awaytotal>
<homerotationnumber>304</homerotationnumber>
<hometeam>Marlins (Florida)</hometeam>
<homemoney>+110</homemoney>
<homeline>off</homeline>
<hometotal>u8.5(-120)
</hometotal>
</entry>
ideally each of those would become a var inside a loop which inserts the data into the database. please point me in the right direction. thank you.