Wildhalf

That's exactly what I'm trying to do. Add a new entry to the array then rotate the array and update database

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

sorry that was my fault that should be 5, 6,7 If you look at first link you will see what my table looks like the second one was me trying to ask with out showing the table... stupid really

I Have asked on stack overflow but im not getting a good answer so decided to come here. I am a learn as you go php programmer.... but think i am a bit out data by the looks of things any way if you look at the following question it will show you what i am trying to do http://stackoverflow.com/questions/13238787/php-select-update-statement-to-return-and-update-a-multi-dimensional-array & http://stackoverflow.com/questions/13117872/php-rotate-and-adding-to-an-array thanks in advance to anyone who can help