SAINTS HERITAGE SOCIETY CUSTOM PAGE

Players per Season


$counting=0; if ($_POST['seasoninput']!="" ) { $seasoninput=$_POST['seasoninput']; } $thisyear=date("Y"); if ($seasoninput == "" ) {$seasoninput="$thisyear";} echo'SEASON
Season:


$seasoninputorig = $seasoninput; $seasoninput = substr("$seasoninput", 0, 4); echo "Season : $seasoninputorig"; echo ' echo ""; $aresult = mysqli_query("SELECT * FROM fusion_shs_matches where season like '$seasoninput%' "); while ($adata = mysqli_fetch_array($aresult)) { $seq=$adata['seq']; $hresult = mysqli_query("SELECT * FROM fusion_shs_match_players WHERE match_number = '$seq' order by player_surname "); while ($data = mysqli_fetch_array($hresult)) { $player=$data['player']; $player_surname=$data['player_surname']; addslashes($player_surname); $player_surname = str_replace("'", "\'", $player_surname); $result = mysqli_query ("INSERT shs_perseason_temp SET player='$player',player_surname='$player_surname' ");} } $hresult = mysqli_query("SELECT DISTINCT player FROM shs_perseason_temp order by player_surname "); while ($data = mysqli_fetch_array($hresult)) { $player=$data['player']; $player_surname=$data['player_surname']; $counting++; $fresult = mysqli_query("select * from shs_players where num= '$player' "); while ($fdata = mysqli_fetch_array($fresult)) { $namefor=$fdata['namefor']; $namesplit= "$namefor"; list ($fdata['namefor'])=split(' ', $namesplit); echo " } } echo "

Total Players for $seasoninputorig = $counting

Player Name :CareerAppSubTriesGoalsDGsNotes
"; echo ''.$fdata['namefor'].' '. $fdata['namesur'].''. $fdata['careereras'].''. $fdata['statapp'].''. $fdata['statsub'].''. $fdata['statt'].''. $fdata['statg'].''. $fdata['statdg'].''. $fdata['notes'].'
"; $hresult = mysqli_query("truncate table shs_perseason_temp");



We are working on these pages, please try back again if content is missing.

Copyright © Saints Heritage Society 1999-2024.