Free2Code
 
Time: 2008-11-21, 04:45am
Free2Code » Forums » PHP » Nestled Array calculation.
Please login or register to post a reply.
Nestled Array calculation.
Subject: Nestled Array calculation.  ·  Posted: 2008-04-10, 01:39am
Rank: ? (60)
Member #: 22843
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?

Joseph

 
  Reply to this ·  Post link ·  Top
Subject: Re: Nestled Array calculation.  ·  Posted: 2008-04-11, 05:51am
Rank: ? (767)
Member #: 11085
Seems a simple quadratic formula. I would guess in the form y = Ax^3+Bx^2+Cx, just plug in some numbers to find A, B, and C. X is the number of generations, y is the number of people.

» Post edited 2008-04-11, 05:51am by relpats_eht.

- relpats_eht
 
  Reply to this ·  Post link ·  Top
Subject: Re: Nestled Array calculation.  ·  Posted: 2008-05-06, 12:42pm
Rank: ? (60)
Member #: 22843
Well, so far i have made it work but with another format, i got a class from phpclasses.org

The only problem i`m having now is the HTML display, i have been thinking one million ways to display it.

The return is an Array that looks like this
Code:
  1. Array
  2. (
  3.     [0] => Array
  4.         (
  5.             [0] => 1009603
  6.             [section_id] => 1009603
  7.             [1] => 4
  8.             [section_left] => 4
  9.             [2] => 11
  10.             [section_right] => 11
  11.             [3] => 1
  12.             [section_level] => 1
  13.             [4] => Joseph Abah
  14.             [section_name] => Joseph Abah
  15.         )
  17.     [1] => Array
  18.         (
  19.             [0] => 1009956
  20.             [section_id] => 1009956
  21.             [1] => 5
  22.             [section_left] => 5
  23.             [2] => 8
  24.             [section_right] => 8
  25.             [3] => 2
  26.             [section_level] => 2
  27.             [4] => Onuche Mikel
  28.             [section_name] => Onuche Mikel
  29.         )
  31.     [2] => Array
  32.         (
  33.             [0] => 1005539
  34.             [section_id] => 1005539
  35.             [1] => 9
  36.             [section_left] => 9
  37.             [2] => 10
  38.             [section_right] => 10
  39.             [3] => 2
  40.             [section_level] => 2
  41.             [4] => Owen Joncena
  42.             [section_name] => Owen Joncena
  43.         )
  45. )


so the Array are grouped in level.
so i want to display all level 1 or a different row then
level 2 on a different row.

Thank you

» Post edited 2008-05-06, 12:42pm by joefazee.
 
  Reply to this ·  Post link ·  Top

Pages: 1

Please login or register to post a reply.

Copyright © Free2Code Online · Privacy Policy

Generated in 47.7ms using 3 (8 cached) SQL queries.

Valid HTML 4.01 Transitional   Valid CSS!

icons