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 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 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
Archived
This topic is now archived and is closed to further replies.