Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Genealogical PHP tree

Status
Not open for further replies.

technisup

Programmer
Sep 28, 2007
41
US
Hi, i'm trying to find information about how to create a genealogical php tree from a MYSQL db.

These are my tables:

table:CV
ID
Name

table: HERITAGE
ID
Father
Mother

is there any who could help me with it?
Thanks in advance for the help.
 
Please can you provide more detailed information about what you're trying to achieve.

Clive
Runner_1Revised.gif

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096
 
thanks for your post.

What i'm trying to achieve is to build a genealogical php tree for horses extracting data from the tables described above. That would be the same for humans, and everytime you go deep the tree you can be able to see , who's your father, mother, grandparents and so on.

 
i can't help thinking that a flat table structure is better. you're going to have the same entity in multiple tables. I recall writing a bloodstock database about 20 years ago - it was a flat file then but worked well.

anyway, i think Clive was really asking what you mean by a "tree". are you looking for a graphical representation, or a straightforward collection of textual statements with links but no graphical rendition, or what? how many levels up and down do you want to show?

do you always start from a descendant and work into the ancestors or from a given horse, do you want the ancestors and the descendants?
 
Thanks for ur posting.

are you looking for a graphical representation, or a straightforward collection of textual statements with links but no graphical rendition, or what?
What i'm trying to achieve is a graphical representation of a genealogy of a horse

how many levels up and down do you want to show?
as many levels down as possible. n levels.

do you always start from a descendant and work into the ancestors or from a given horse, do you want the ancestors and the descendants?
from a given horse and i want the ancestors and so on

If you need more information just let me know.
Regards.
 
i'm confused

to question two you replied as many levels down as possible.

to question three you replied that you want the ancestors (i.e. up).

can you clarify?

also for each level up or down, do you want to show each of the other horse's trees or just the direct lineage?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top