[RESOLVED] PHP, MYSQL & Tree Style Menu's

[kestral321]

Hi all,

Am stuck with a menu i am trying to create so thought it was time to ask the experts!.

What i currently have is 2 tables in a database, these are:
Section_Table : Containing : Section_ID(Numeric),Section_Name(Varchar)
Group_Table : Containing : Section_ID(Numeric),Group_ID(Numeric),Group_Name(Varchar)

What i want to do is create a tree style menu (Drop Down/Expandable) using the data from this database.

The Parent items should be the Section_Name titles with the child objects being the Groups where the Section_ID field matches the Parent Object. An example would be:

Folder 1(Section_ID=1)
-->subfolder 1(Section_ID=1 | Group_ID=26)
-->subfolder 2(Section_ID=1 | Group_ID=27)

Any help at all with how i can do this would be greatly apreciated as currently i am stumped, i am however able to print a plain text list in the correct order. Lost and Confused!

Many Thanks
John

[alimadzi]

I would recommend nested unordered lists (<ul>) because they are semantic and also easy to style with CSS. Just search for "css menu tutorial". So the HTML would look like this...

<ul>
  <li>Section 1
    <ul>
      <li>Group 1</li>
      <li>Group 2</li>
    </ul>
  </li> 
  <li>Section 2
    <ul>
      <li>Group 3</li>
      <li>Group 4</li>
    </ul>
  </li>
</ul>

Let us know if you have further questions.

[kestral321]

Many thanks, after googling css menu tutorial i found exactly what you explained above, working like a charm.

[alimadzi]

kestral321 wrote:

Many thanks, after googling css menu tutorial i found exactly what you explained above, working like a charm.

Happy to help. CSS styling of lists is pretty amazing stuff. Enjoy!