https://www.icyphoenix.com/viewtopic.php?f=26&t=7759&p=52221#p52221
-----------------------------------
KugeLSichA
Fri 01 Apr, 2011 23:22

Mysql Query With Rank
-----------------------------------
Hey guys...

Yeah its me again  :shock:  :mrviolet:  8)

Another thing i need to figure out...

the DB structure is with id, user_id, score,

i have a user_id and a score (number)... and i want to count the entries from the DB... order by score and gives back the Rank/place/count if the user_id matches...

for example:

id=1 user_id=2 score=50 <--------- 1. place
id=2 user_id=3 score=23 <--------- 3. place
id=3 user_id=7 score=34 <--------- 2. place

i hope you can understand what i mean, and help me with that... thanks...