List:General Discussion« Previous MessageNext Message »
From:mysql Date:January 29 2006 9:48pm
Subject:Re: display a hierarchic tree
View as plain text  
Hi Jochen.

An alternative approach could be to pull all the values out 
of the database using select * from ..., and then build the 
tree-structure in your application logic. Insert the 
relevant values returned from mysql in the appropriate 
places of the tree-structure in the app code.

Keith

In theory, theory and practice are the same;
In practice they are not. 

On Sun, 29 Jan 2006, Jochen Kaechelin wrote:

> To: mysql@stripped
> From: Jochen Kaechelin <fvgi242ss@stripped>
> Subject: display a hierarchic tree
> 
> I have the following table:
> 
> mysql> select * from link_categories;
> +----+-------+-------------+---------------+-----------+---------+
> | id | level | category_id | category      | parent_id | deleted |
> +----+-------+-------------+---------------+-----------+---------+
> |  1 |     1 |        1000 | Software      |         0 |       0 |
> |  2 |     1 |        2000 | Harware       |         0 |       0 |
> |  3 |     2 |        1001 | Virenscanner  |      1000 |       0 |
> |  4 |     2 |        1003 | Packprogramme |      1000 |       0 |
> |  5 |     3 |        1004 | Linux         |      1001 |       0 |
> |  6 |     3 |        1005 | Windows       |      1001 |       0 |
> |  7 |     4 |        1006 | Windows XP    |      1005 |       0 |
> |  8 |     2 |        1007 | Sniffer       |      1000 |       0 |
> |  9 |     4 |        1008 | Debian Woody  |      1004 |       0 |
> | 10 |     1 |      100000 | Vermischtes   |         0 |       0 |
> +----+-------+-------------+---------------+-----------+---------+
> 10 rows in set (0.24 sec)
> 
> and I want to display a tree like:
> 
> 	Software
> 	   Virenscanner
> 	     Linux
>                Debian Woody
>              Windows
>                Windowsd XP
> 	   Packprogramm
>            Sniffer
> 	Hardware
> 	Vermischtes
> 	....
> 
> Can someone give me hint how to build a query?
> 
> I run MySQL 4.1.x and 5.0.x and I use PHP.
> 
> Thanx.
Thread
display a hierarchic treeJochen Kaechelin29 Jan
  • Re: display a hierarchic treePeter Brawley29 Jan
  • Re: display a hierarchic treemysql29 Jan
  • Re: display a hierarchic treeGleb Paharenko30 Jan
    • Finding the row number satisfying a conditon in a result setJacques Brignon30 Jan
      • Re: Finding the row number satisfying a conditon in a result setJake Peavy30 Jan
    • Re: display a hierarchic tree(Pete Harlan)30 Jan