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
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;
> ++---+-+--
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:
>
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
I have the following table:
mysql> select * from link_categories;
++---+-+---+---+-+
| id | level | category_id | category | parent_id | deleted |
++---+-+---+---+-+
| 1 | 1 |1000 | So