Kicken, Sorry for being so confusing.
Basically i am building a rotator script.
Here is how my database looks:
both id & fb_user_id are unique for every entry.
What i am doing is building a kind of affiliate system with signup page with a form. I am rotating the sponsors link on the page so they are in order related to who joined first. When someone gets a signup they are put on the end of the rotation again untill they have say 2 signups.
So when a new user signs up via the rotator page the order goes from
fb_user_id - oder
1 - 1
2 - 2
3 - 3
to this
fb_user_id - oder
1 - 4
2 - 1
3 - 2
4 - 3
so the new member goes in 3rd in line and the person who referred them goes in right behind them in 4th unless that had been there 2nd signup in this case they will no longer be in the rotation.
Do you have any more questions?? Hope this makes it a bit clearer