Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

load nested categories from database

i have a list of 495 categories which are nested up to 4 levels., example

main category
         |_sub categoey 1.0
                      |_sub categoey 1.0.0
                                     |_sub categoey 1.0.0.0

now if i am thinking of making a tree menu, so what do u guys suggest. shall i make a function which recursively makes list every time a new page is loaded or i just make a function in admin area so that when ever i wanna update category, i just click on button and it writes in file .. say menu.php and it gets stored in regular <ul><li> format so that continuous database read can be avoided.

if there is a better way to implement this, plz suggest so. also i would like ur suggestions about best recursive function to generate category list.

thanks a lot
0
nandananushil1
Asked:
nandananushil1
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
check this article on mysql site, it's very complete about managing/querying hierarchical data:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now