Hello,

I am working on a mlm script and I am not sure if i am going in the right direction. The mlm script is 3 (width) x 9 (level) based. The design of my database is following:

Code:
CREATE TABLE IF NOT EXISTS `members` (
  `memb_id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `memb_pid` mediumint(9) NOT NULL,
  `memb_pos` tinyint(1) NOT NULL,
  `memb_fullname` varchar(50) NOT NULL,
  PRIMARY KEY (`memb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Now as per the design its simple enough and i with just memb_pid can add as many members by using the memb_pos (position left, mid or right).

As 1 member can only have 3 sub-members that i have also covered.

Now there are payouts at each different level.

Eg. If member 1 who is on top joins 3 members below him then he gets 200 for each member.

Then if those 3 members join 3x3 = 9 members below them then they each get 200 for each but the 1st top member gets 100 for each member.

How to make this kind of thing ?



Thanks.