Please can you provide more detailed information about what you're trying to achieve.
Clive
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"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
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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.