ofmyst

I have tried to make this work, but with parents, children, their children, etc., and starting from first generalation having seven children, it is becoming very unwieldy from an organizational standpoint and tracking who goes with who in the mysql. Is there perhaps another way of approaching this that keeps the families "together" in the database?

I'm sorry it was a week. Life threw some curve balls my way! Okay, I think I get the gist of it. I'm very new to mysql and php so it usually takes me alot of trial and error, but mostly help from the kindness of others. Thank you.

I am sorry, but I don't exactly understand how the database table structure would work to accomodate the next generations. How would the fields be constructed? Thank you!

Now that I have a very basic understanding of mysql and php I would like to use it for my website that contains my famiily tree. Each page is a branch of the tree - the parents and their children. When you click on one of the children they become the parents and their children are listed. This goes on down the line. It is very unwieldly right now, as I manually write each page and every change has to be reflected in the next generation page. Is there a good way to structure mysql to make this function efficiently? Right now we go as far as five generations. My instinct is to have a table within a table but I do not know if this can be done. And if so if it is the most efficient way to handle the task at hand. Any help will be very much appreciated.