[PHP-DB] RE: Tree Display

2001-07-30 Thread Mikusch, Rita
Have your table set up with the following two fields (among others!): -Category -Parent Result1 parent = 0 (it has no parent). Item1 parent is Result1 (ie the parent field of item1 is result1's unique identifier). Item2 parent is Result1. Result2 parent = 0. Result2's children have Result2 as

[PHP-DB] Re: Tree Display

2001-07-27 Thread Hugh Bothwell
Sharif Islam [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am still trying to figure out how to do it. I want to display my result from the data base in tree/menu like system. Could you give us your SELECT statement and one row of returned data? So the