To get XML from url and insert sorted into table.

[Fredrik Svensson]

Hi!

Im new to MySQL and have some problems. Im trying to make a Stored Procedure I will start to describe the scenario:

1. I want to get the xml via a http link, it returns s xml page.
2. Store the XML i a either, a) temporary table b) a variable c) a fil
3. Extract and insert structured (well as structured as could be).

I have access to a betting company’s database (via XML) and they deliver via a http that returns a XML. This XML contains the description of for example 13 matches in football. Ex teams, odds, number of the game, league and so on.

Example XML:
- <match>
<matchnummer>1</matchnummer>
<matchid>285052</matchid>
<ligaid>9</ligaid>
<sasongid>44</sasongid>
<hemmalag>Fulham</hemmalag>
<bortalag>Tottenham</bortalag>
<hemmalagkort>Fulham</hemmalagkort>
<bortalagkort>Tottenham</bortalagkort>
<matchstart>2010-03-06 18:20:00</matchstart>
</match>
- <match>

This is what should generate a insert row (plus which round, which i stated once in the top of the file).

Is there any one that could help?

Thanx in advance

// Fredrik Svensson
// [e-mail]