Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: Database tree structure functionality

    I have a MySql database that calculates costs of a company using a managerial accountancy method (activity based costing).
    The database uses 6 tables with information about the departments (cost centers), activity of the departments (process steps) etc. Using a few query’s one can find out which are the total costs per product.

    Now, I should start to implement a functionality that must be able to arrange all departments in a hierarchy, i.e. in a tree structure, and store it in a table of the database. The task is not to program such functionality, but to research and find a software library where this problem is already solved.
    If anyone has encountered this problem before or if you have some advice that could help me, I would be thankful.

    Thank you!

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    We had a short discussion on hierarchies a while back (if that's the issue).

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    this might help: Categories and Subcategories
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •