Looking for a way to track referrals. Each person is allowed 10 on their first level then the 11th needs to spill over. Those ten are allowed 10 etc.
My problem is how to track this in a data base (Mysql)php.
We pay for 6 levels of commission only(a 10 x 6 matrix yields over 1 million on the 6th level).
I don't really understand threads and I a "tree" doesn't seem to fit the bill. I would end up with too much duplicated data.
If I needed to know how many referrals someone had, my query would have to be able to return the proper results.
Any thoughts or ideas.