Nested xml structure inserted in mysql tree

[huygenn]

I have this xml structure\[code\]<locations> <location name="x" id="1" type="suburb"/> <location name="y" id="2" type="region"> <children> <location name="x" id="1" type="suburb"/> <location name="z" id="3" type="suburb"/> </children> </location></locations>\[/code\]I need to use php to insert it into a tree structure in mysql with left and right nodes because this list gets updated frequently