Yahoo Store XML into MySQL Database

Most of my experience is in PHP and MySQL, but I'm by know means an expert, and this latest problem has me stumped. I am working with the Yahoo Store interface for someone. Their wizards (the only way to use their system) create an XML file of the catalog. There is no way to change the actual structure or way the XML file is written. The actual values within it are automatically updates, but the structure remains the same. I am looking for a piece of PHP script, that when called, will extract the values from the XML document and import them into a MySQL table. I do not have the MySQL tables created, but will create them however you instruct me to. The most important thing is that the values can be transposed from XML to MySQL accurately and simply. The XML file can be viewed at: [login to view URL] Please build for: PHP, Unix Server, MySQL database. Thank you. Dustin ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Web Server OS: Linux 2.4.20 Recent: PHP, MySQL, Apache