Re: Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019
| From: | Daniel Brown | Date: | Wed, 09 Apr 2008 21:21:02 +0000 |
| Subject: | Re: Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019 | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44874@lists.php.net to get a copy of this message | ||
On Wed, Apr 9, 2008 at 5:09 PM, A. Joseph <joefazee@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!