connect_errno)
{ die('Failed to connect to database.'); }
$conn->set_charset("utf8");
$scriptname = "headtohead.php?" . $_SERVER['QUERY_STRING'];
$nav_id = "mat";
$prefdata = $conn->query("SELECT * FROM tplss_preferences WHERE ID = '0'");
if($prefdata->num_rows)
{
$pdata = $prefdata->fetch_assoc();
}
mysqli_free_result($prefdata);
if(isset($_SESSION['defaultseasonid_tplss']) || isset($_SESSION['defaultmatchtypeid_tplss']))
{
$seasonid = $_SESSION['defaultseasonid_tplss'];
$compid = $_SESSION['defaultmatchtypeid_tplss'];
}
else
{
$_SESSION['defaultseasonid_tplss'] = $pdata['DefaultSeasonID'];
$_SESSION['defaultmatchtypeid_tplss'] = $pdata['DefaultMatchTypeID'];
$seasonid = $_SESSION['defaultseasonid_tplss'];
$compid = $_SESSION['defaultmatchtypeid_tplss'];
}
if(isset($_REQUEST['id']))
$id = $_REQUEST['id'];
$opponent_stmt = $conn->prepare("
SELECT
OpponentName,
OpponentShort,
OpponentInfo,
OpponentNationID
FROM
tplss_opponents
WHERE
OpponentID = ?
LIMIT 1
");
$opponent_stmt->bind_param( "i", $id);
$opponent_stmt->execute();
$opponent_stmt->bind_result($name, $short, $info, $nationid);
$opponent_stmt->fetch();
$info = str_replace("
", "\n", $info);;
$nation_url = "images/flags/flag_" . $nationid . ".jpg";
$image_url = "images/opps/" . $id . ".jpg";
$opponent_stmt->free_result();
$get_all_seasons = $conn->query("SELECT * FROM tplss_seasonnames ORDER BY SeasonName DESC");
$get_all_comps = $conn->query("SELECT * FROM tplss_matchtypes WHERE MatchGrade != 0 ORDER BY MatchTypeName");
?>
| Head to Head Record | ()