On Wed, Apr 9, 2008 at 5:09 PM, A. Joseph <joefazee@xxxxxxxxx> 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!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
