Hi,
need help on creating a tree view menu out of an existing mysql db.
The db has a user_table with the following structure:
user_id type=char ---->members nickname
user_name type=char.
id1 type=char ---->company headquarters name
id2 type=char ----->company town location
id3 type=char ----->company street location
rows example:
id1=ibm id2=rome id3=rome-south user_id=marc user_name=pippo
id1=ibm id2=rome id3=rome-south user_id=jack user_name=storm
id1=beneton id2=amsterdam id3=downtown user_id=anna user_name=green
the tree should be structured like this:
-ibm
-rome
-rome-south
-marc pippo
-jack storm
+amsterdam
id1==grand grandfather id2==grandfather id3==father user_id==child
any tips on how to realize that??
