I am running this multiple times, so here it what it looks like. A game is chosen, and outputs game 'A'. Then I use sql right now to change a variable called 'viewed' to 1 for each player in that game. Then total number of views is calculated for each player, then the algorithm chooses the next game, and I updated the views, and so forth. So the algorithm ends up with a list of lets say 100 games (in one column), and then I have to look up that list, and update the views for the players in those 100 games. I do want to randomly select which player I see based on game A. So we see game A, I want to randomly select one player I see. Then I can write code to mark other players in that game as seen based on some criteria I have. So it might randomly select player 12, then based on my criteria it would also mark player 45. Are you saying the problem is as it adds to the list, the randomly chosen player would change each time?
... View more