<?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?