Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: updating database
12-12-2011, 04:13 AM #1
- Join Date
- Dec 2011
- Thanked 0 Times in 0 Posts
So i have a database with player and their rank. So when rank(5) player challenge rank(3) player and rank(5) beats rank(3). Rank(5) gets rank(3) ranking. What is the best way to do this without doing like 6 or 7 queries.
12-12-2011, 07:12 AM #2
Code:UPDATE players AS p1, players AS p2 SET p1.rank = p2.rank WHERE p1.rank < p2.rank AND p1.playerid = $winnerid AND p2.playerid = $loserid
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.