For me ... this is a tough one! I hope you can help!
I found an online rss xml feed for foreign currency exchange rates. I need to parse the xml feed into an array ...
so I can then import into a mysql table (which I feel pretty good about accomplishing).
BUT I've NO idea how XML stuff works (excuse pretty huge ignorance) ...
I'm hoping to do this:
- read XML file (see link) into these variables:
: exch_rate_date = (the date of the published rates (i.e. 2004-04-23))
: exch_rate_ccy [1,2,3 ... 6,7,8] = 'Malaysia' / 'Hong Kong' etc.
: exch_rate_num [1,2,3 ... 6,7,8] = 0.7287 etc (as a numeric with 4 decimal places)
That way ... I can then do a simple 'insert' into my database of the array contents.
Thanks for any guidance!
The Opinion Exchange