86Stang Posted May 14, 2007 Share Posted May 14, 2007 In my database each record consists of the following columns: cat_num cat_name sub_cat I would like to somehow display this as follows: sub_cat - cat_name - cat_name - cat_name sub_cat - cat_name - cat_name - cat_name sub_cat - cat_name - cat_name - cat_name ...and so on. All I can come up with is: sub_cat | cat_name sub_cat | cat_name sub_cat | cat_name sub_cat | cat_name Basically I only want to list the sub_cat once and show all records associated with it underneath it. I'm sure it's straight-forward but my novice rump just isn't seeing the light. Link to comment https://forums.phpfreaks.com/topic/51277-how-do-i-display-this/ Share on other sites More sharing options...
georg Posted May 14, 2007 Share Posted May 14, 2007 Maybe you should move to Nested Sets.. I think, they are much simpler, you can read the whole tree with one query... Link to comment https://forums.phpfreaks.com/topic/51277-how-do-i-display-this/#findComment-252590 Share on other sites More sharing options...
86Stang Posted May 14, 2007 Author Share Posted May 14, 2007 Could I get an idea on how to do that? Link to comment https://forums.phpfreaks.com/topic/51277-how-do-i-display-this/#findComment-252772 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.