chmpdog Posted December 23, 2008 Share Posted December 23, 2008 I have a page, which is basically a high score system. I need to find out what place the user is, so I need to find the highest value in the row place, and add 1. How do you do this? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/138202-get-the-row-with-the-highest-value/ Share on other sites More sharing options...
Maq Posted December 23, 2008 Share Posted December 23, 2008 SELECT user, MAX(score) FROM table; UPDATE table SET score = score+1 WHERE user = $user Quote Link to comment https://forums.phpfreaks.com/topic/138202-get-the-row-with-the-highest-value/#findComment-722522 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.