[insert_php] $db = mysql_connect(«localhost»,»mobile»,»R0e5W5n4″);
mysql_select_db(«sinfo662_bmfl», $db);
$allplayers = mysql_query(«SELECT DISTINCT player_id FROM wz_leagueengine_season_matches_events WHERE league_id = ‘1’ AND season_id = ‘2547’ AND event_id IN (34, 2527) ORDER BY player_id», $db);
while ( $row1 = mysql_fetch_array($allplayers)) $masallplayers[] = $row1[«player_id»];

//Игроки с голами
//Общее количесво игроков
$plcount = count($masallplayers); // общее число игроков, которые отличились
while ($x++<$plcount-1) $masallplayers1[] = $masallplayers[$x]; // цикл для перебора всех игроков foreach ($masallplayers1 as $player_id) { $sql3 = mysql_query("SELECT * FROM wz_leagueengine_season_matches_events WHERE league_id = '1' AND season_id = '2547' AND event_id = '34' AND player_id=$player_id", $db); $num_rows = mysql_num_rows($sql3); // получение числа голов для игрока $sql31 = mysql_query("SELECT * FROM wz_leagueengine_season_matches_events WHERE league_id = '1' AND season_id = '2547' AND event_id = '2527' AND player_id=$player_id", $db); $num_rows1 = mysql_num_rows($sql31); // получение числа пасов для игрока $total = $num_rows1+=$num_rows; // сумма голов и пасов //Установление соответствия ID-Игрок mysql_query("SET NAMES 'utf8'"); $res = mysql_query("SELECT * FROM wz_leagueengine_data WHERE id='$player_id'", $db); while ( $row2 = mysql_fetch_array($res)) $fio = $row2["data_value"]; $array5["$fio"] = "$total"; // задание массива игрок (пасы) } // вывод таблицы ГОЛ_ПАС mysql_close($db); arsort($array5); echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
foreach($array5 as $k3=>$v3) {
echo ‘

‘;
}
echo ‘

‘; echo ‘Игрок’; echo ‘	‘; echo ‘Гол+Пас’; echo ‘
‘.$k3.’	‘.$v3.’

‘;

[/insert_php]