marcin_koss Posted February 9, 2010 Share Posted February 9, 2010 Here's the mysql table ID 1 2 3 4 5 6 7 8 9 NAME web development computer graphics photography php javascript 360 pano HDR images jquery ajax PARENT 0 0 0 1 1 3 3 5 5 I need to output this data in hierarchical format like this: web development - php - javascript - jquery - ajax computer graphics photography - 360 pano - HDR image I tried to figure this out but I'm out of ideas...anyone? Quote Link to comment https://forums.phpfreaks.com/topic/191437-need-help-outputing-mysql-data-in-hierarchical-format/ Share on other sites More sharing options...
PravinS Posted February 9, 2010 Share Posted February 9, 2010 You have to use recursive function to get data in required format. I have create on multilevel menu with same recursive functionality, you can refer it. Download URL: http://www.phpclasses.org/browse/package/5927.html refer functions.php file, where it have getMenu() and getChild() functions. Quote Link to comment https://forums.phpfreaks.com/topic/191437-need-help-outputing-mysql-data-in-hierarchical-format/#findComment-1009259 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.