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