Filtering xml data

[EDN Admin]

Ok let say i have the following xml file
<pre class="prettyprint prettyprinted" style=" <span class="tag <Users><span class="pln
<span class="tag <User><span class="pln
<span class="tag <Name><span class="pln David<span class="tag </Name><span class="pln
<span class="tag <Attempts><span class="pln
<span class="tag <Place><span class="pln Paris<span class="tag </Place><span class="pln
<span class="tag <Date><span class="pln 3/29/2012<span class="tag </Date><span class="pln
<span class="tag <Duration><span class="pln 50 seconds<span class="tag </Duration><span class="pln
<span class="tag <Distance><span class="pln 100<span class="tag </Distance><span class="pln
<span class="tag </Attempts><span class="pln
<span class="tag <Attempts><span class="pln
<span class="tag <Place><span class="pln New York<span class="tag </Place><span class="pln
<span class="tag <Date><span class="pln 7/28/2012<span class="tag </Date><span class="pln
<span class="tag <Duration><span class="pln 30 seconds<span class="tag </Duration><span class="pln
<span class="tag <Distance><span class="pln 100<span class="tag </Distance><span class="pln
<span class="tag </Attempts><span class="pln
<span class="tag <Attempts><span class="pln
<span class="tag <Place><span class="pln Paris<span class="tag </Place><span class="pln
<span class="tag <Date><span class="pln 8/19/2012<span class="tag </Date><span class="pln
<span class="tag <Duration><span class="pln 70 seconds<span class="tag </Duration><span class="pln
<span class="tag <Distance><span class="pln 60<span class="tag </Distance><span class="pln
<span class="tag </Attempts><span class="pln
<span class="tag <Attempts><span class="pln
<span class="tag <Place><span class="pln New York</Paris
<span class="tag <Date><span class="pln 9/29/2012<span class="tag </Date><span class="pln
<span class="tag <Duration><span class="pln 60 seconds<span class="tag </Duration><span class="pln
<span class="tag <Distance><span class="pln 200<span class="tag </Distance><span class="pln
<span class="tag </Attempts><span class="pln
<span class="tag </User><span class="pln
<span class="tag <User><span class="pln
<span class="tag <Name><span class="pln Lenny<span class="tag </Name><span class="pln
<span class="tag <Attempts><span class="pln
<span class="tag <Place><span class="pln Paris<span class="tag </Place><span class="pln
<span class="tag <Date><span class="pln 9/29/2012<span class="tag </Date><span class="pln
<span class="tag <Duration><span class="pln 51 seconds<span class="tag </Duration><span class="pln
<span class="tag <Distance><span class="pln 130<span class="tag </Distance><span class="pln
<span class="tag </Attempts><span class="pln
<span class="tag </User><span class="pln
<span class="tag </Users>[/code]
So what im trying to find is particular data between 2 time frames depending on what user i chose from a drop down list
Let Say i chose Daniel and i chose a timeframe from a starttextbox to be 2/20/12 and a endtextbox to be 9/30/12 So what i want is a listbox (or anything similiar) that will display the following
User: Daniel
Information from 2/20/12 to 9/30/12
Average Distance from Paris:80
Average Distance form New York:150
Average Duration from Paris:60 seconds
Average Duration from New York:45 seconds
Total Duration:105 seconds
Total Distance:230
Is this possible to do? If so i need help to do so, any help would be greatly appreciated
I just have problems filtering multiple data

View the full article