# Problem in xml tree menu and PHP/SQL

**URL:** <https://forum.kirupa.com/t/problem-in-xml-tree-menu-and-php-sql/298073>\
**Category:** Uncategorized\
**Created:** [October 13, 2009, 12:32pm UTC](https://forum.kirupa.com/t/problem-in-xml-tree-menu-and-php-sql/298073 "2009-10-13T12:32:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![peyvand](https://avatars.discourse-cdn.com/v4/letter/p/7feea3/32.png) [@peyvand](https://forum.kirupa.com/u/peyvand)\
**Post date:** [October 13, 2009, 12:32pm UTC](https://forum.kirupa.com/t/problem-in-xml-tree-menu-and-php-sql/298073/1 "2009-10-13T12:32:58Z")

</div>

hi every body .  
i have a important project for big organization .  
this file work with SQL/PHP that php give a query and write a xml code.  
The following :

```php
<root>
         <menu id="1" sub="0" name="BENZ" />
         <menu id="2" sub="0" name="BMW" />
         <menu id="3" sub="0" name="AUDI" />

         <menu id="4" sub="1" name="classic" />
         <menu id="5" sub="1" name="avantgard" />
         <menu id="6" sub="1" name="sport" />

         <menu id="7" sub="2" name="5series" />
         <menu id="8" sub="2" name="7series" />

         <menu id="9" sub="3" name="audi tt" />
         <menu id="10" sub="3" name="audi R8" />
</root>

```

if sub = 0 this is root menu or main menu  
if sub = 1 this is sub menu of benz or id 1  
or so …

php file : “[http://www.sinamoonart.com/peyvand/business.php](http://www.sinamoonart.com/peyvand/business.php)”

i can’t Remove this problem but i have a file for file .  
just help me.  
I worked on this problem, 3 weeks  
thanks .