Table: sportleagueteams

Assigns a sports team to a league/season.

Tool: Sport Leagues
Associated Objects: SportLeagueTeams, SportLeagueTeam

Fields

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("dbconn.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM sportleagueteams");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $lid = $resRow["lid"];  //Sports league id
 $tid = $resRow["tid"];  //Sports team id
 $coach = $resRow["coach"];  //
}

Other Sport Leagues Tables

sportgames     sportleagues     sportleagueteams     sportpositions     sportstats     sportstattypes     sportteamplayer     sportteams