Google Answers Logo
View Question
 
Q: PHP Hierarchy as Document ( No Answer,   0 Comments )
Question  
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
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy