Re: display a hierarchic tree

2006-01-30 Thread Pete Harlan
On Mon, Jan 30, 2006 at 03:04:20PM +0200, Gleb Paharenko wrote: > Hello. > > This is not an exact answer on your question, however it could be > interesting for you: > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html This is a good article. One thing it leaves out of the dis

Re: display a hierarchic tree

2006-01-30 Thread Gleb Paharenko
Hello. This is not an exact answer on your question, however it could be interesting for you: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Jochen Kaechelin wrote: > I have the following table: > > mysql> select * from link_categories; > ++---+-+--

Re: display a hierarchic tree

2006-01-29 Thread mysql
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

Re: display a hierarchic tree

2006-01-29 Thread Peter Brawley
Jochen, ...I want to display a tree like: Software Virenscanner Linux Debian Woody Windows Windowsd XP Packprogramm Sniffer Hardware Vermischtes It looks more like a parts