Help me for formate XML to HTML Output

HTML & CSS
1 
<?xml version="1.0" encoding="UTF-8"?> 

<priceResponse> <customerNo>3465346346</customerNo> 

<userName>sales@insid.com</userName> 
<PriceAvailabilityList> 
<SKU>4638028</SKU>
 <mfgPN>BT457AA#ABC</mfgPN>
 <mfgCode>16996</mfgCode> 
<status>Active</status>  
<description>PAVILION P6627C-B PC BUNDLE</description> 
<GlobalProductStatusCode>Active</GlobalProductStatusCode> 
<price>684.71</price> 
<totalQuantity>456</totalQuantity> 
<AvailabilityByWarehouse> 
<warehouseInfo> 
<number>26</number> <zipcode>B3S 1B3</zipcode> <city>Halifax, NS</city> <addr>Chain Lake Drive</addr></warehouseInfo>  
<qty>0</qty>
</AvailabilityByWarehouse> 
<AvailabilityByWarehouse> 
<warehouseInfo> 
<number>29</number> <zipcode>N1H 1B4</zipcode> <city>Guelph, ON</city> <addr>Woodlawn Road West</addr></warehouseInfo>
 <qty>0</qty></AvailabilityByWarehouse>
 <AvailabilityByWarehouse>
 <warehouseInfo> 
<number>31</number>  <zipcode>T2C 4G6</zipcode> <city>Calgary, AB</city> <addr>AVE SE</addr></warehouseInfo>
 <qty>0</qty>
</AvailabilityByWarehouse> 
<AvailabilityByWarehouse>
 <warehouseInfo>
 <number>32</number> <zipcode>V7C 4N3</zipcode> <city>Richmond, BC</city> <addr>Hollybridge Way, Unit 180</addr>
</warehouseInfo>  
<qty>456</qty>
</AvailabilityByWarehouse> 
<AvailabilityByWarehouse>
 <warehouseInfo> 
<number>98</number> 
<zipcode>00000</zipcode>
 <city>MFG Drop Shipped</city> 
<addr>MFG Drop Shipped</addr></warehouseInfo> 
<qty>0</qty></AvailabilityByWarehouse> 
<lineNumber>1</lineNumber>
</PriceAvailabilityList>
</priceResponse>

I need php or xsl so I can show only the
City Qty in a table format and at the end totalQuantity also skip the last record of warehouseInfo.

Can anybody help me please to show this as required?

2

Solved

3

Now I can show Realtime Inventory :slight_smile: