You don't need a matrix for parent-child relations, you need a tree. Try
getting a copy of Joe Celko's book. It's pretty much the bible on recursive
SQL as I understand it:
http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202/

hth,

Yves
------ Original Message ------
Received: Tue, 23 Sep 2008 04:09:30 PM CDT
From: "A. Joseph" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Matrix programming

LIKE..
remember every child is also parent

parent on level 0 earn 5% of each fee paid by left leg downline
                         earn 3% of each fee paid by right leg downline
parent on level 1 earn $5
parent on level2 earn $4
after this first deal
another deal started from level 1

Now what take the parent to those levels?

parent bring 3 Ps, each 3 Ps bring 3 Es. parent move to level 0
3 Es bring 3 Fs and 3 Fs bring 3 Gs each. parent move to level 1

remember 3 Ps will now move to level 0, when parent move to level 1

something like that, i want to learn how to code it myself.
if matrix caculation is a wrong terms for this, then i`m sorry.


On 9/23/08, YVES SUCAET <[EMAIL PROTECTED]> wrote:
>
> I don't quite see where the matrix-calculations come in.
>
> ------ Original Message ------
> Received: Tue, 23 Sep 2008 03:41:51 PM CDT
> From: "A. Joseph" <[EMAIL PROTECTED]>
> To: "YVES SUCAET" <[EMAIL PROTECTED]>
> Subject: Re: [PHP-DB] Matrix programming
>
> Multi level marketing, data will be arranged in hierarchical structure, the
> system will need to auto pay when user get to some level or have specific
> amount if people under him/she, I think u understand how MLM works?
>
>
>
> Thank u
>
>
> On 9/23/08, YVES SUCAET <[EMAIL PROTECTED]> wrote:
> >
> > Do you mean multi level marketing? What kind of matrix calculations? What
> > sort
> > of data do the matrices include?
> >
> > And what does this have to do with databases? Do you need to store matrix
> > data
> > in your db?
> >
> > ------ Original Message ------
> > Received: Tue, 23 Sep 2008 12:29:40 PM CDT
> > From: "A. Joseph" <[EMAIL PROTECTED]>
> > To: "Micah Gersten" <[EMAIL PROTECTED]>Cc: "php list" <
> > php-db@lists.php.net>
> > Subject: [PHP-DB] Matrix programming
> >
> > I need to do some stuff on MLM system so i will be using matrix
> caculation,
> > i need a tutorial on it.
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> I develop dynamic website with PHP & MySql, Let me know about your site
>
>
>
>
>


-- 
I develop dynamic website with PHP & MySql, Let me know about your site





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to