n ($n) лучших из всего, что есть"); echo("Пример использования: http://northernwind.spb.ru/ela/?n=4
"); $link = mysqli_connect('localhost', 'ela', 'ela_pwd00,'ela'); if (!$link) { die('Ошибка соединения: ' . mysqli_error($link )); } echo 'Исходные данные в Excel
'; echo ' php скрипт '; echo '

Исходные данные (Результат в низу)

'; $sql="select * from result order by sportsmen_id,score desc"; mysqli_multi_query($link,$sql ); $result = mysqli_store_result($link); echo mysqli_error($link ); echo(""); while ($row = mysqli_fetch_assoc($result)) { echo ''; echo ''; echo ''; } echo('
sportsmen_idcompetition_idОчки (score)
'.$row['sportsmen_id'].''.$row['competition_id'].''.$row['score'].'
'); //$db_selected = mysqli_select_db('ela', $link); $sql=" set @rn1 =1; set @smen =''; select sportsmen_id,sum(score) x from ( select competition_id,sportsmen_id,score,@rn1 := if(@smen=sportsmen_id,@rn1+1,1) as denseRank, @smen:=sportsmen_id from (select competition_id,sportsmen_id,score from result order by sportsmen_id,score desc) A ) B where denseRank<=$n group by sportsmen_id order by x desc;"; echo 'Запрос:
'.$sql; mysqli_multi_query($link,$sql ); mysqli_next_result($link); mysqli_next_result($link); $result = mysqli_store_result($link); echo mysqli_error($link ); echo("
"); while ($row = mysqli_fetch_assoc($result)) { echo ''; } echo('
sportsmen_idСумма n ($n) лучших
'.$row['sportsmen_id'].''; echo $row['x'].'
'); mysqli_close($link); ?>