MySQL-Based Navigation

[jaquito13]

I am trying to make a php script that will produce the following output:

<div id="nav_parent">Parent 1
  <ul>
    <li>
      <div id="nav_child"><a href="/child1/">Child 1</a></div>
    </li>
    <li>
      <div id="nav_child"><a href="/child2/">Child 2</a></div>
    </li>
    <li>
      <div id="nav_child"><a href="/child3/">Child 3</a></div>
    </li>
    <li>
      <div id="nav_child"><a href="/child4/">Child 4</a></div>
    </li>
  </ul>
</div>
<div id="nav_parent">Parent 2
  <ul>
    <li>
      <div id="nav_child"><a href="/childa/">Child A</a></div>
    </li>
    <li>
      <div id="nav_child"><a href="/childb/">Child b</a></div>
    </li>
  </ul>
</div>

from a database. I want to store all my navigation variables in a database, with the following structure:

Any help would be greatly appreciated!

[planetsim]

Id have the table set up quite a bit differently

id | nav_name | nav_link | nav_parentid

Not sure what the nav_child is there for is that for the displayorder?

The parentid e.g. would be if its the main navigation link (section header) that its -1 else its the Section headers Id

an example

id | nav_name | nav_link | nav_parentid 
1  | Test      | /test   | -1
2  | Test Cat 2 | /test2 | -1
3  | Link 1    | /link1 | 2

Link 1 would be in section Test Cat 2