0) { // Does this team exist? $team_exist_query = 'SELECT COUNT(*) FROM sportsdb_teams WHERE teamid = ' . $teamtosort; $team_exist_check = mysql_query($team_exist_query); if (mysql_result($team_exist_check, 0) == 0) { die ('No such team exists'); } // MySQL code to select a specific team $team_specific_sort = 'AND (sportsdb_wins.winner = ' . $teamtosort . ' OR sportsdb_wins.loser = ' . $teamtosort . ') '; } // Show upcoming games only if ($team_game_filter == 1) { $score_sort = 'ASC'; $score_game_filter = 'AND sportsdb_wins.winortie = 3 '; } // Show past scores only if ($team_game_filter == 2) { $score_sort = 'DESC'; $score_game_filter = 'AND sportsdb_wins.winortie != 3 '; } if ($result_exist) { $query = "SELECT teamid, teamname, nickname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra, (teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed, (teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points, $winning_pct_formula AS winningpct, (teamwins - teamlosses - teamforfeits) AS leadervalue FROM sportsdb_teams WHERE teamdiv = {$divs['divid']} ORDER BY leadervalue DESC, teamties DESC LIMIT 1"; $result = mysql_query($query) or die ("Error in query: $query"); $results = mysql_fetch_array($result, MYSQL_ASSOC); $winningpct = number_format($results['winningpct'], 0); } ?> '; } function get_team_name ($teamid) { $team_name_query = 'SELECT teamname FROM sportsdb_teams WHERE teamid = ' . $teamid; $team_name_check = mysql_query($team_name_query); if (mysql_num_rows($team_name_check) == 0) { return 'No such team exists'; } else { return mysql_result($team_name_check,0); } } ?>

Logo	Domácí		Skóre		Hosté	Logo
	' . "\n"; ?>			'; ?>			' . "\n"; ?>