function get_team

function get_team($team_id) {

        global $db;

        $query = "SELECT * FROM teams
                  LEFT JOIN countries ON teams.fk_country_id = countries.id
                  LEFT JOIN games ON teams.fk_game_id = games.game_id
                  WHERE team_id = $team_id";

        if ($result = $db->query($query)) {
            if ($result->num_rows) {

               $post = $result->fetch_object();

            }
            $result->free(); // Frigør hukommlsen
        }

        return $post;
    }