Using php 5.0 to upload xml into Mysql database [closed]

[Anterstot]

I have a xml as follows- \[code\]<?xml version="1.0" encoding="UTF-8"?><result><item> <mid>2557</mid> <merchantname>DVD Players</merchantname> <linkid>1000012</linkid> <createdon>2006-09-30/20:04:17</createdon> <sku> JR-E-12324</sku> <productname>Sony Blu-Ray DVD Player</productname> <category> <primary>Electronics</primary> <secondary>TV . Video</secondary> </category> <price currency="JPY">59704</price> <upccode>4901340995017</upccode> <description> <short>Awesome Pictures</short> <long>Watch all your HD-DVDs</long> </description> <keywords>DVD Player~~BluRay~~SONY</keywords> <linkurl>http://somelink.com</linkurl> <imageurl>image.gif</imgurl></item>\[/code\]I need to upload above xml to mysql table sing php. can someone help ?thanks