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" <joefazee@xxxxxxxxx> To: "YVES SUCAET" <yves.sucaet@xxxxxxx> Subject: Re: 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 <yves.sucaet@xxxxxxx> 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" <joefazee@xxxxxxxxx> > To: "YVES SUCAET" <yves.sucaet@xxxxxxx> > Subject: Re: 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 <yves.sucaet@xxxxxxx> 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" <joefazee@xxxxxxxxx> > > To: "Micah Gersten" <micah@xxxxxxxxxxx>Cc: "php list" < > > php-db@xxxxxxxxxxxxx> > > Subject: 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