How to output data in xml?

How can I fetch a XML feed and write it to a MySQL database?

• I'm not a XML crack, but maybe anyone here has a good answer for me :-) I have a XML Feed, like this one here: <music> <artist id=Madonna> <album id=Hang Up> <song>Push it</song> <song>Hollywood</song> </album> </artist> </music> now I want to put these data in a MySQL database for an easier handling and output. So what I want is a database like this: Music Artist | Album | Song Madonna | Hang Up | Push it Madonna | Hang Up | Hollywood anyones knows how I can do that? is there maybe a opensource script I can use? thanks

• Answer:

  I am a cracker jack xml guy... I remember writing a generic xml to mysql... it's not that hard, not exactly the format you want.. but your 'feed' is not valid xml in the first place.