I need to parse an xml document to get the information like the following at (the following being the most important part)
what I need to do is to parse the xml file and find the JOB_ID and then grab the number 60905057 from the body and change a filename and do some database stuff using the Access_code and adt_company_id. I can handle all that, just need to know how to parse the XML and grab the following information.
<SECTION compulsory="0">
<TITLE><![CDATA[JOB_ID]]></TITLE>
<BODY><![CDATA[60905057]]></BODY>
<FROM><![CDATA[Database query]]></FROM>
</SECTION>
<SECTION compulsory="0">
<TITLE><![CDATA[ACCESS_CODE]]></TITLE>
<BODY><![CDATA[7001]]></BODY>
<FROM><![CDATA[Database query]]></FROM>
</SECTION>
<SECTION compulsory="0">
<TITLE><![CDATA[ADT_COMPANY_ID]]></TITLE>
<BODY><![CDATA[70231]]></BODY>
<FROM><![CDATA[Database query]]></FROM>
</SECTION>
any help would be appreciated