How to find the sorted row number?

Question

MySQL

Good evening. There is a rating among users, you need to find the number of the sorted line by rating, thereby the place itself. How to do it?

Answer 1

right in the query is this how it should be done? sort in descending order of rating and, sorting through the records on the client, assign them numbers.
row_number in 8+ versions. at the end of the link article how to get around the lack of window functions in lower versions

Answer 2

Pass a variable to a function. If this answer does not suit you, then lightly smoke a book on php.