uhm i am currently working on a Multilevel Marketing System. i'm using php.
it is a genealogy that is 2x2 matrix.
every member can have 2 downlines.
my problem is how can i count all his total downlines per side.
example chart.
SIDE A SIDE B
member1
member2 member3
member4 member5 member6 member7
member8 NULL NULL NULL NULL NULL NULL NULL
total Downline at Side A : 4
total Downline at Side B : 3
this is my table
memberid | parentid | child_a | child_b
sorry for my bad english.
can you give me any idea on how to this? and code this then post it here for help again? pls?