Prev: Nestling Array in PHP from MySql
Next: Date calculation from MySql table
From: "A. Joseph" on 9 Apr 2008 17:02
The question is.

Some nestled calculation.
How did club freedom did the calculation, or how will the database structure
looks like?

*The example is -: *

*Joseph* gave birth to *John*, *James,* and *Johnson*
*John* gave birth to* Peter*, *Matter*, and *Potter*
James gave birth to Juliana, Justin, and *Jane*
Johnson gave birth to Jak, Jake and Jacob

Continuously like that,
Peter the son of John also gave birth to another 3 children
And the 3 children also keep giving birth to 3 children each, so
How can I calculate the Total descendants of Joseph?
How can I calculate the total descendants of John or any of the grand
children?

Because each of the children also start having grand children, while Joseph
grand descendants increases.

I want to use MySql/PHP
The concept is Like http://www.disneytreasures.biz/ or ClubFreedom

All I want to do is to know who bring who?
From: "A. Joseph" on 9 Apr 2008 17:09
The question is.

Some nestled calculation.
How did club freedom did the calculation, or how will the database structure
looks like?

*The example is -: *

*Joseph* gave birth to *John*, *James,* and *Johnson*
*John* gave birth to* Peter*, *Matter*, and *Potter*
James gave birth to Juliana, Justin, and *Jane*
Johnson gave birth to Jak, Jake and Jacob

Continuously like that,
Peter the son of John also gave birth to another 3 children
And the 3 children also keep giving birth to 3 children each, so
How can I calculate the Total descendants of Joseph?
How can I calculate the total descendants of John or any of the grand
children?

Because each of the children also start having grand children, while Joseph
grand descendants increases.

I want to use MySql/PHP
The concept is Like http://www.disneytreasures.biz/ or ClubFreedom

All I want to do is to know who bring who?
From: "Daniel Brown" on 9 Apr 2008 17:21
On Wed, Apr 9, 2008 at 5:09 PM, A. Joseph <joefazee(a)gmail.com> wrote:
> The question is.
>
> Some nestled calculation.
> How did club freedom did the calculation, or how will the database structure
> looks like?
>
> *The example is -: *
>
> *Joseph* gave birth to *John*, *James,* and *Johnson*
> *John* gave birth to* Peter*, *Matter*, and *Potter*
> James gave birth to Juliana, Justin, and *Jane*
> Johnson gave birth to Jak, Jake and Jacob

Using a parent-child relationship, exactly as in nature.

MySQL:
db_name.people
id INT ( 8 ) AUTO_INCREMENT NOT NULL
full_name VARCHAR ( 255 )
child_of INT ( 8 ) NOT NULL
num_children INT ( 2 ) NOT NULL

Then do some simple queries like this:
<?php
// First record
$sql = "INSERT INTO people(full_name,child_of,num_children)
VALUES('".$fullName."','0','0')";

// For each child....
// $parentID is the `id` column for the record of the parent of this child.
$sql = "INSERT INTO people(full_name,child_of,num_children)
VALUES('".$fullName."','".$parentID."','0')";
$sql = "UPDATE people SET num_childen=(num_children + 1) WHERE
id='".$parentID."'";
?>

And so forth. Code sanity and such are your responsibility, but
that should kick-start the idea for you.

--
</Daniel P. Brown>
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
 | 
Pages: 1
Prev: Nestling Array in PHP from MySql
Next: Date calculation from MySql table