Quote Originally Posted by PeejAvery View Post
You should have an additional table for game data. I accidentally said column, but meant table. That way you can reference the latest matches and figure out the winners. It should have the following columns.

  • game_id
  • timestamp
  • player_1_id (match with user's table)
  • player_2_id (match with user's table)
  • winner_id (match with user's table)
thaks for clearing that up. i would assume that i could use the generation code in the above post to generate and then link said login id to the player1/2 columns.