Parsing XML

Parsing XML

I am at a loss.

How do I parse this xml? I cannot seem to be able to loop through the "results". What I want as output is:

id
name
description
label value
label value
label value
label value
...

Please help I am going bald.

Warren




<?xml version="1.0" encoding="utf-8"?>
<tests>

<test id="test 1">
<id>test 1</id>
<name>Device Testing KPI</name>
<description>A summarized Device testing KPI for dates between 01/01/2014 and 06/15/2014 which omits a count of tests conducted.</description>
<results>
<label_1>Commercial devices launched</label_1><value_1>16</value_1>
<label_2>SUs deployed</label_2><value_2>72</value_2>
<label_3>Test requests</label_3><value_3>207</value_3>
<label_4>Number of Tests conducted</label_4><value_4>OMIT</value_4>
<label_5>Trips to Canada</label_5><value_5>31</value_5>
<label_6>New Issues logged</label_6><value_6>3</value_6>
<label_7>Issues fixed, retested and quantified</label_7><value_7>167</value_7>
<label_8>$ of resolved tickets</label_8><value_8>$3.65M</value_8>
</results>
</test>
<test id="test 2">
<id>test 2</id>
<name>Device Testing for connectivity</name>
<description>A summarized Device testing connectivity.</description>
<results>
<label_1>Commercial devices launched</label_1><value_1>16</value_1>
<label_2>SUs deployed</label_2><value_2>72</value_2>
<label_3>Test requests</label_3><value_3>207</value_3>
<label_4>Number of Tests conducted</label_4><value_4>OMIT</value_4>
<label_5>Trips to Canada</label_5><value_5>31</value_5>
<label_6>New Issues logged</label_6><value_6>3</value_6>
<label_7>Issues fixed, retested and quantified</label_7><value_7>167</value_7>
<label_8>$ of resolved tickets</label_8><value_8>$3.65M</value_8>
</results>
</test>
</tests>