I require a small bit of code to populate a jTree structure from data in a mySQL database.
Tree structure
State
|+ --- ACT
| |+----Suburb
| |+---Location
|
|+ --- NSW
| |+----Suburb
| |+---Location
|
etc... The State, Suburb, Location and other information is contained in a single table in mySQL DB. I have created the end result using PHP and HTML Select / Options but now wish to do the same using jTree.
Once the tree is created I require the ID associated with the selected tree leaf to be provided which I then use push out to another PHP page which reads in information from another DB and populates other fields on my dashboard... Only the population and creation of the tree from mySQL is required.
Example Tree structure and mySQL DB/Table/Data dumps attached for reference.
Regards, Stuart Hall