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? Link to comment https://forums.phpfreaks.com/topic/82211-can-a-query-do-this/ 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... Link to comment https://forums.phpfreaks.com/topic/82211-can-a-query-do-this/#findComment-417814 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.