Jump to content

can a query do this?


tehprince

Recommended Posts

I'm looking to build a menu / sitemap out of my database, an example of my table structure is:

 

ID          PageTitle          ParentID

=======================================

1          Home                  0

2          About Us              1

3          Contact Us          1

4          About Us / Sub 1  2

5          About Us / Sub 2  2

6          About Us / LVL 3    5

 

So essentially this menu should display as follows:

Home

    About Us

        About Us / Sub 1

        About Us / Sub 2

            About Us / LVL 3

    Contact Us

 

Is it possible to write a query that would output menu in that specific order?

Link to comment
https://forums.phpfreaks.com/topic/82211-can-a-query-do-this/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.