distinct xml

Hi! all,
pls help me on this.

<acoount>
	<Hotel>
		<datime>12/09/2005 12:06:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>22</DUR>
	</Hotel>
	<Hotel>
		<datime>12/09/2005 20:06:23</datime>
		<type>2</type>
		<paid><500</paid>
		<DUR>25</DUR>
	</Hotel>
	<Hotel>
		<datime>13/03/2005 12:06:23</datime>
		<type>1</type>
		<paid><1200</paid>
		<DUR>32</DUR>
	</Hotel>
	<Hotel>
		<datime>16/09/2005 22:56:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>15</DUR>
	</Hotel>
	<Hotel>
		<datime>17/09/2005 12:56:51</datime>
		<type>2</type>
		<paid><1500</paid>
		<DUR>19</DUR>
	</Hotel>
	<Hotel>
		<datime>17/09/2005 12:06:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>12</DUR>
	</Hotel>
	<Hotel>
		<datime>18/09/2005 19:06:23</datime>
		<type>1</type>
		<paid><1320</paid>
		<DUR>32</DUR>
	</Hotel>
	<Hotel>
		<datime>18/09/2005 12:06:23</datime>
		<type>2</type>
		<paid><400</paid>
		<DUR>24</DUR>
	</Hotel>
	<Hotel>
		<datime>22/09/2005 12:16:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>20</DUR>
	</Hotel>
	<Hotel>
		<datime>22/09/2005 12:06:23</datime>
		<type>2</type>
		<paid><550</paid>
		<DUR>31</DUR>
	</Hotel>
	<Hotel>
		<datime>23/09/2005 12:06:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>32</DUR>
	</Hotel>
	<Hotel>
		<datime>25/09/2005 12:06:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>27</DUR>
	</Hotel>
	<Hotel>
		<datime>25/09/2005 12:06:23</datime>
		<type>1</type>
		<paid><1000</paid>
		<DUR>17</DUR>
	</Hotel>

its a xml file. One guy used to go to hotel. He may go
twice also per a day. From this how we can find if
type='1' for day howmuch he paid. I have 2 disply for
every day howmuch he spent in hotel if type='1' and
the total duration when type='1' per day.
Cud u pls guide me how can I solve this.

Regards,
Sree.


	
		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com