tehprince Posted December 18, 2007 Share Posted December 18, 2007 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? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 18, 2007 Share Posted December 18, 2007 Why does the page title already "know" about the parent ID? that's bad... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.