![]() |
|
|
| Subject:
PHP Hierarchy as Document
Category: Computers > Programming Asked by: universityresource-ga List Price: $5.00 |
Posted:
09 Nov 2004 06:24 PST
Expires: 09 Dec 2004 06:24 PST Question ID: 426565 |
Hi,
We have a dataset in two tables in MySQL.
We would like to find an easy example or tutorial on how to view what
is a hierarchical structure as a document using PHP and MySQL.
Table1 contains the hierarchy node details, table2 contains
relationships between items in table1
Table1
Entry_id
Notes
Table2
PrimaryKey
Up (contains a Table1.entry_id)
Down (contains a Table1.entry_id)
This is the data structure as represented by Table2:
1 2
3 4 5 6
7 8 9 10
The numbers refer to entry_id's of notes in table1. If we used the
positions instead it might read:
Chairman
President CEO
vp-this vp-that etc...
We would like the data to display in document format from top to
bottom then up to the nearest juncture and so on, as depicted in the
following order:
1
3
7
8
4
5
9
10
2
6 |
|
| There is no answer at this time. |
|
| There are no comments at this time. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |