Non-Domestic Players

Competition: American Argentina Australia Austria Belgium Brazil Cameroon Canada Croatia Denmark England Estonia Faroe Islands France Germany Greece Italy Ivory Coast Lithuania Netherlands Northern Ireland Norway Poland Republic of Ireland Slovakia South Africa Spain Switzerland Trinidad & Tobago

---

query(" SELECT a.id as id, apps + subapps as total FROM ( SELECT P.PlayerID AS id, P.PlayerFirstName AS firstname, P.PlayerLastName AS lastname, COUNT(A.AppearancePlayerID) AS apps FROM tplss_players P LEFT OUTER JOIN tplss_appearances A ON A.AppearancePlayerID = P.PlayerID WHERE P.PlayerNationID = $nation GROUP BY P.PlayerID ) as a INNER JOIN ( SELECT P.PlayerID AS id, COUNT(SU.SubstitutionPlayerIDIn) AS subapps FROM tplss_players P LEFT OUTER JOIN tplss_substitutions SU ON SU.SubstitutionPlayerIDIn = P.PlayerID WHERE P.PlayerNationID = $nation GROUP BY P.PlayerID ) as b on a.id = b.id HAVING total > 0 ORDER BY total DESC, lastname ASC, firstname ASC LIMIT 0,18446744073709551615 ") or die(mysqli_error($conn)); $i=0; if($get_player_totals->num_rows < 1) { echo"

No record could be found of players from $natdata[NationName] who have made competitive appearances for $pdata[TeamName].

"; } else { echo"

Below is a list of players from $natdata[NationName] who have made competitive appearances for $pdata[TeamName].

"; } while($data = $get_player_totals->fetch_assoc()) { if($data['total'] > 0) { $i++; $pid = $data['id']; $get_player_info = $conn->query("SELECT DATE_FORMAT(PlayerDOB, '%d/%m/%Y') AS dob, YEAR(PlayerDOB) AS year, PlayerNationID AS nationid, PlayerFirstName AS firstname, PlayerLastName AS lastname FROM tplss_players WHERE PlayerID = $pid"); $playerdata = $get_player_info->fetch_assoc(); echo" "; } } mysqli_free_result($get_player_totals); ?>

Name	DOB	Nation	Apps	Goals
$i. $playerdata[firstname] $playerdata[lastname]	"; if($playerdata['year'] > '1870') echo"b. $playerdata[dob]"; else echo""; echo"	"; // DISPLAY NATIONALITY FLAG echo"	$data[total]	"; $get_goals_totals = $conn->query("SELECT COUNT(GoalPlayerID) AS goals FROM tplss_goals WHERE GoalPlayerID = $pid AND GoalOwn != 1"); $goaldata = $get_goals_totals->fetch_assoc(); if($goaldata['goals'] < 1) $goals = 0; else $goals = $goaldata['goals']; echo" $goals

query(" SELECT a.id as id, apps + subapps as total FROM ( SELECT P.PlayerID AS id, P.PlayerFirstName AS firstname, P.PlayerLastName AS lastname, COUNT(A.AppearancePlayerID) AS apps FROM tplss_players P LEFT OUTER JOIN tplss_appearances A ON A.AppearancePlayerID = P.PlayerID WHERE P.PlayerTrialist != 1 AND P.PlayerNationID = $nation GROUP BY P.PlayerID ) as a INNER JOIN ( SELECT P.PlayerID AS id, COUNT(SU.SubstitutionPlayerIDIn) AS subapps FROM tplss_players P LEFT OUTER JOIN tplss_substitutions SU ON SU.SubstitutionPlayerIDIn = P.PlayerID WHERE P.PlayerTrialist != 1 AND P.PlayerNationID = $nation GROUP BY P.PlayerID ) as b on a.id = b.id HAVING total < 1 ORDER BY total DESC, lastname ASC, firstname ASC LIMIT 0,18446744073709551615 ") or die(mysqli_error($conn)); $i=0; if($get_zero_player_totals->num_rows < 1) { } else { echo"

Below is a list of players from $natdata[NationName] who have been signed to $pdata[TeamName] but have not made a competitive appearance. They may have been involved in regional competitions, testimonials or friendly matches.

"; } while($data = $get_zero_player_totals->fetch_assoc()) { if($data['total'] < 1) { $i++; $pid = $data['id']; $get_player_info = $conn->query("SELECT DATE_FORMAT(PlayerDOB, '%d/%m/%Y') AS dob, YEAR(PlayerDOB) AS year, PlayerNationID AS nationid, PlayerFirstName AS firstname, PlayerLastName AS lastname FROM tplss_players WHERE PlayerID = $pid"); $playerdata = $get_player_info->fetch_assoc(); echo" "; } } mysqli_free_result($get_zero_player_totals); ?>

Name	DOB	Nation
$i. $playerdata[firstname] $playerdata[lastname]	"; if($playerdata['year'] > '1870') echo"b. $playerdata[dob]"; else echo""; echo"	"; // DISPLAY NATIONALITY FLAG echo"