Forth Wanderers
Head to Head - Clydebank FC 1965-Present

Venue	Pld	Won	Drn	Lst	For	Agst	+/-
Home	2	2	0	0	8	2	+6
Away	1	1	0	0	2	0	+2
Neutral	0	0	0	0	0	0	0
Total	3	3	0	0	10	2	+8

All Friendly Matches - Clydebank FC 1965-Present

$get_matches = $conn->query(" SELECT M.MatchID AS id, M.MatchPlaceID AS place, M.MatchPublish AS publish, M.MatchNeutral AS neutral, M.MatchGoals AS goals, M.MatchGoalsOpponent AS goals_against, M.MatchStadium AS stadium, M.MatchAttendance AS attendance FROM bank_matches M, bank_matchtypes MT WHERE MatchOpponent = '$id' AND MatchGoals IS NOT NULL AND MatchGoalsOpponent IS NOT NULL AND M.MatchTypeID = MT.MatchTypeID AND MT.MatchGrade = 0 AND M.MatchAban != 1 AND $eraCondition ORDER BY M.MatchDateTime DESC"); } else { $get_matches = $conn->query(" SELECT M.MatchID AS id, M.MatchPlaceID AS place, M.MatchPublish AS publish, M.MatchNeutral AS neutral, M.MatchGoals AS goals, M.MatchGoalsOpponent AS goals_against, M.MatchStadium AS stadium, M.MatchAttendance AS attendance FROM bank_matches M, bank_matchtypes MT WHERE MatchOpponent = '$id' AND MatchGoals IS NOT NULL AND MatchGoalsOpponent IS NOT NULL AND M.MatchTypeID = MT.MatchTypeID AND M.MatchTypeID LIKE '$compid' AND M.MatchAban != 1 AND $eraCondition ORDER BY M.MatchDateTime DESC"); } $f_home_matches = 0; $f_home_wins = 0; $f_home_losses = 0; $f_home_draws = 0; $f_home_goals = 0; $f_home_goals_against = 0; $f_away_matches = 0; $f_away_wins = 0; $f_away_losses = 0; $f_away_draws = 0; $f_away_goals = 0; $f_away_goals_against = 0; $f_neutral_matches = 0; $f_neutral_wins = 0; $f_neutral_losses = 0; $f_neutral_draws = 0; $f_neutral_goals = 0; $f_neutral_goals_against = 0; $f_total_matches = 0; $f_total_wins = 0; $f_total_losses = 0; $f_total_draws = 0; $f_total_goals = 0; $f_total_goals_against = 0; $i=0; while($data = $get_matches->fetch_assoc()) { $place[$i] = $data['place']; $publish[$i] = $data['publish']; $neutral[$i] = $data['neutral']; $goals[$i] = $data['goals']; $goals_against[$i] = $data['goals_against']; // COUNT WINS if($goals[$i] > $goals_against[$i]) { if($neutral[$i] == 1) { $f_neutral_matches++; $f_neutral_wins++; $f_neutral_goals = $f_neutral_goals + $goals[$i]; $f_neutral_goals_against = $f_neutral_goals_against + $goals_against[$i]; } else { if($place[$i] == 1) { $f_home_matches++; $f_home_wins++; $f_home_goals = $f_home_goals + $goals[$i]; $f_home_goals_against = $f_home_goals_against + $goals_against[$i]; } elseif($place[$i] == 2) { $f_away_matches++; $f_away_wins++; $f_away_goals = $f_away_goals + $goals[$i]; $f_away_goals_against = $f_away_goals_against + $goals_against[$i]; } } } // COUNT LOSSES elseif($goals_against[$i] > $goals[$i]) { if($neutral[$i] == 1) { $f_neutral_matches++; $f_neutral_losses++; $f_neutral_goals = $f_neutral_goals + $goals[$i]; $f_neutral_goals_against = $f_neutral_goals_against + $goals_against[$i]; } else { if($place[$i] == 1) { $f_home_matches++; $f_home_losses++; $f_home_goals = $f_home_goals + $goals[$i]; $f_home_goals_against = $f_home_goals_against + $goals_against[$i]; } elseif($place[$i] == 2) { $f_away_matches++; $f_away_losses++; $f_away_goals = $f_away_goals + $goals[$i]; $f_away_goals_against = $f_away_goals_against + $goals_against[$i]; } } } // COUNT DRAWS elseif($goals[$i] == $goals_against[$i]) { if($neutral[$i] == 1) { $f_neutral_matches++; $f_neutral_draws++; $f_neutral_goals = $f_neutral_goals + $goals[$i]; $f_neutral_goals_against = $f_neutral_goals_against + $goals_against[$i]; } else { if($place[$i] == 1) { $f_home_matches++; $f_home_draws++; $f_home_goals = $f_home_goals + $goals[$i]; $f_home_goals_against = $f_home_goals_against + $goals_against[$i]; } elseif($place[$i] == 2) { $f_away_matches++; $f_away_draws++; $f_away_goals = $f_away_goals + $goals[$i]; $f_away_goals_against = $f_away_goals_against + $goals_against[$i]; } } } $i++; } mysqli_free_result($get_matches); ?>

Venue	Pld	Won	Drn	Lst	For	Agst	+/-
Home							0
Away							0
Neutral							0
Total	0	0	0	0	0	0	0