Hey! I got a pvp server and we are thinking of making a player's latest matches being saved into the database which would be used on our website. We are going to save all the 1vs1 matches into the database and I cant figure out how I wanna do this and how the database table would look like. First of all, check out the player profile site here: http://pvpheroes.no/profile.php?name=VengeaPlays Im planning adding the Latest matches on the right side of the Hero Stats module. This is the General table: This is the Free-for-all table: For the 1vs1 matches table I would have to save Player 1's UUID and Player 2's UUID, who won and the score. But how would I be able to display it on the profile page? This is the select I currently use on the profile page: SELECT * FROM General, ffa WHERE General.UUID=ffa.UUID AND General.Name='$name' I use the general table to get the players username, which allows me to drop the mojangs API. But how would I be able to get Player 1's and Player 2's usernames and display it on the website? This is my suggestion on the Matches table: Since Im getting the player's UUID from the select, would the second select look like this? Select * from Matches WHERE Player1='$UUID' AND Player2='$UUID' $UUID would be the UUID I get from general table from the first select. Now comes my biggest challenge, how would I get the second player username? For example; In 1 match I am player1 but in another match im player2. Would I have to make 2 selects, where I take UUID from the Player1 row and UUID from the Player2 row and some way get their usernames from the General table? Im sorry if I am sounding very confusing, but I tried to explain this the best I could.