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@lists.mysql.com > From: Jochen Kaechelin <[EMAIL PROTECTED]> > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
