samra

thanks for your reply. searching for the common ancestor can work out too with this single table? am just a newbie in php, just know CRUD so far.

I want to create a family tree site in php. That site should be able to display the parent and child nodes along with their spouse. I also need to display relation between the member of any nodes level to any other person on the basis of their common ancestor in the tree. Now am totally at loss regarding the db schmea. so far i have created a table named family_tree which include the following fields: family_id name spouse_name parent_level (e.g 1,2,2 so on nodes levels) children it all seems quite vague sort of thing to me. dont know where exactly should be proceeding. how many tables i will be needing? how these tables should be related? please reply. thanks