Cannot parse this XML - help please!

[memerson]

I am trying to parse this XML, but for some reason SimpleXML will not do the trick. I am a little stuck as I do not know what else to use - it may be the XML is not a standard structure, what with all the colons in the IDs...but any help would be appreciated! Thank you.

XML below:

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

http://iqwareinc.com/WebRes">

<xs:schema id="dsRoomsLocations" xmlns="" xmlns:xs="

http://www.w3.org/2001/XMLSchema"

xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="dsRoomsLocations" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>

<xs:element name="Code" type="xs:int" minOccurs="0" />
<xs:element name="Name" type="xs:string" minOccurs="0" />
<xs:element name="ExtraAmt" type="xs:double" minOccurs="0" />
<xs:element name="ExtraAmtType" type="xs:short" minOccurs="0" />
<xs:element name="BillingType" type="xs:short" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>

</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<dsRoomsLocations xmlns="">
<Table diffgr:id="Table1" msdata:rowOrder="0">
<Code>16</Code>
<Name>Disney Area, Resort Homes</Name>

<ExtraAmt>0</ExtraAmt>
<ExtraAmtType>0</ExtraAmtType>
<BillingType>6</BillingType>
</Table>
<Table diffgr:id="Table2" msdata:rowOrder="1">
<Code>15</Code>
<Name>Low Cost, Disney Area</Name>

<ExtraAmt>0</ExtraAmt>
<ExtraAmtType>0</ExtraAmtType>
<BillingType>6</BillingType>
</Table>
<Table diffgr:id="Table3" msdata:rowOrder="2">
<Code>211</Code>
<Name>Regal Oaks Resort, Kissimmee</Name>

<ExtraAmt>0</ExtraAmt>
<ExtraAmtType>0</ExtraAmtType>
<BillingType>6</BillingType>
</Table>
</dsRoomsLocations>
</diffgr:diffgram>
</DataSet>

 

[tsuji]

You have to read and to understand the manual on [tt]SimpleXMLElement->registerXPathNamespace()[/tt] in order to do the parsing.

http://hk2.php.net/manual/en/function.simplexml-element-registerXPathNamespace.php