[php]
global $team;
$team = $_GET[‘team’];
if(is_null($team)){
$team = “senior”;
}
$stmt = ‘SELECT * FROM players WHERE current = 1 AND team = “senior”‘;
global $senior_players;
$senior_players = $wpdb->get_results(‘SELECT * FROM players WHERE current = 1 AND team = “senior” ORDER BY squadno’);
$stmt = ‘SELECT * FROM players WHERE current = 1 AND team = “under18″‘;
global $youth_players;
$youth_players = $wpdb->get_results(‘SELECT * FROM players WHERE current = 1 AND team = “under18” ORDER BY squadno’);
[/php]

[php]
global $senior_players;
global $pid;
$pid = $_GET[‘pid’];
if(is_null($pid)){
$pid = $senior_players[0]->pid;
}
global $player;
$player = $wpdb->get_row( $wpdb->prepare( ‘SELECT * FROM players WHERE pid = %d’, $pid) );
echo $player->name;
[/php]

Position: [php]global $player; echo $player->position;[/php]

Joined: [php]global $player; echo $player->joined;[/php]

Senior Debut: [php]global $player; echo $player->senior_debut;[/php]

Previous Clubs: [php]global $player; echo $player->prevclubs;[/php]

Home Sponsor

[php]global $player; echo $player->home;[/php]

Away Sponsor

[php]global $player; echo $player->away; [/php]

Bio

[php]global $player; echo $player->bio;[/php]

Senior Player Profiles

[php]
global $team;
global $senior_players;
foreach($senior_players as $squadmem){
echo “[tr style=’text-align:left; font-size:12px;’][td]”.$squadmem->squadno.”[/td][td][a href=’https://www.afcdiamonds.com/player_profiles?pid=”.$squadmem->pid.”&team=”.$squadmem->team.”‘]”.$squadmem->name.”[/a][/td][td] “.$squadmem->position.”[/td][/tr]”;
};
[/php]

[php]include(“senior-stats.php”);[/php]