[php:1:5f6aba733b]
$hero_query = mysql_query ("SELECT * FROM user,stat WHERE stat.id=user.id ORDER by stat.win DESC LIMIT $begin,$row");
$place = $begin;
//Ваше место в рейтинге: ???
while ($hero = mysql_fetch_array($hero_query)){
$place = $place + 1;
echo '<br/>Место: '.$place;
echo '<br/>Имя: '.$hero['name'];
echo '<br/>Побед: '.$hero['win'];
}
[/php:1:5f6aba733b]
$uStat = mysql_fetch_assoc(mysql_query('SELECT `win` as `wins`, (SELECT COUNT(*) FROM `stat` WHERE `win` > `wins`)+1 as `pos` FROM `stat` WHERE `id` = '.$user['id']));
echo 'Ваше место в рейтинге: '.$uStat['pos'].' [ '.$uStat['wins'].' побед ]';