Hello all, I am updating our Affiliate system to be in Php & MySQL. I have run into a problem that I am having hard time to solve and since this is a common aspect of any Affiliate system I thought best to ask you all to see if you based on your experience in same could suggest what is the best way to get this task done. To be exact if the payment for an Affiliate is less than a certain threshold amount then the payment for that month is to be moved into the next month. How does one design this in MySQL & PhP? I cannot visualize it :(




