XML import to MySQL database script

Closed - This job posting has been filled and work has been completed.

Job Description

Our need is to create a flat MySQL table that replaces text from XML lookup lists.

-current field data is: 1.1,1.2,1.4
-lookup values: 1.1=red,1.2=yellow,1.3=green,1.4=blue,1.5=black
-resulting new flat table with field data: red,yellow,blue

Desired product = an automating script that can parse through the single XML file and update all the lookup values into this new database table.

IMPORTANT: This script is needed within the next couple days, so experience and speed is highly desired.

Skills: import