Re: [PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

On Wed, Apr 9, 2008 at 5:09 PM, A. Joseph <[email protected]> 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!