How to parse XML data to MySQL Database and have a connection between them?

[Ranjit D Kumar]

Hey all
I have an xml file, which contains shipping information like locations,weigh t and the price.All these three are interrelated.Th ere are so many locations.Every now and then the prices change and it is becoming difficult for me to go and change manually for all the locations and for all the weight ranges in the xml file.I want the same to be captured in Mysql database.So, whenever the prices go up by say2% or 5%, I will run a update query in Mysql and change the prices and when I change the prices, the same should be reflected in the xml file.Is it possible?Can some help me with this.I have attached the xml file to the post.Thanks a lot in advance.

[jkmyoung]

This is possible in many ways, but what are you using to communicate from xml to the mysql db? Perl? C#? The answers will vary greatly depending on what library sets you are using.

Also, if you had some sort of relevant schema for the affected tables and fields in your database it would help.