https://www.icyphoenix.com/viewtopic.php?f=26&t=7759&p=52224#p52224
-----------------------------------
Informpro
Sat 02 Apr, 2011 01:14

Re: Mysql Query With Rank
-----------------------------------
[code syntax="sql"]SELECT user_id, username, user_rank, user_rank2, user_rank3 ...
FROM USERS_TABLE
ORDER BY score DESC[/code]The PHP code should'nt be too difficult ;-). Something like
[code syntax="php"]<?php $result = $db->sql_result($sql);
$place = 0;
while ($row = $db->sql_fetchrow($result))
{
    echo 'Hi I\' ' . $row['username'] . ', id ' . $row['user_id']  . '. My place is ' . ++$place . ', and my first rank is ' . $row['user_rank'] . '<br />'; //feel free to display more ranks
}[/code]