Women’s Team Pages

include("hafta.inc");

// try get here

$team_id = $_GET[t];

$top10_W = 0;
$top10_L = 0;
$top25_W = 0;
$top25_L = 0;
$top64_W = 0;
$top64_L = 0;

// end get here

$dblink = mysql_connect('localhost', $dbuser, $dbpass);
$dblinked = mysql_select_db($dbname, $dblink);

// echo "

“;
$q12 = “SELECT * FROM w_ranking_data_2010 WHERE ID=’$team_id’”;
$r12 = mysql_query($q12);

while($a12 = mysql_fetch_array($r12))
{
$rank = $a12[Rank];
$Team=$a12[Team];
$Wins=$a12[W];
$Losses=$a12[L];

$team_search=mysql_real_escape_string($Team);

// if($col == ‘#cccccc’) { $col = ‘#ffffff’; } else { $col = ‘#cccccc’; }

echo ““.$Team.”
“;
echo “W-L: “.$Wins.”-”.$Losses.”
“;
echo “Current TCT Ranking: “.$rank.”
“;

}

echo “

“;

$q32 = “SELECT * FROM w_matches_2010 WHERE (Winner=’$team_search’ OR Loser=’$team_search’) ORDER BY Match_Date ASC”;
$r32 = mysql_query($q32);

while($a32 = mysql_fetch_array($r32))
{
$date = $a32[Match_Date];
$Winner=$a32[Winner];
$Loser=$a32[Loser];

if ($Team==$Winner) {
$Opponent=$Loser;
$Result=’W';
} else {
$Opponent=$Winner;
$Result=’L';
}
$opp_search=mysql_real_escape_string($Opponent);

// $excel_timestamp = $date-25567; // 1970-01-01 is day 25567.
// $php_timestamp = mktime(0,0,0,1,$excel_timestamp,1970); // No, really – this works!
// $php_timestamp = $php_timestamp-3600;
// $mysql_timestamp = date(‘Y-m-d’, $php_timestamp); // Or whatever the format is.

$q52 = “SELECT * FROM w_ranking_data_2010 WHERE Team=’$opp_search’”;
$r52 = mysql_query($q52);

// if (is_null(mysql_fetch_array($r52)))
// {
// $opp_id = “99999″;
// }
while($a52 = mysql_fetch_array($r52))
{
$opp_id = $a52[ID];
$opp_rank = $a52[Rank];
$opp_Wins=$a52[W];
$opp_Losses=$a52[L];

if ($opp_ITA_rank==0) {
$opp_ITA_rank=”NA”;
}

if ($opp_ITA_start==0) {
$opp_ITA_start=”NA”;
}

if ($opp_rank<11 AND $Result=='W') {
$top10_W=$top10_W+1;
}
if ($opp_rank<11 AND $Result=='L') {
$top10_L=$top10_L+1;
}
if ($opp_rank<26 AND $Result=='W') {
$top25_W=$top25_W+1;
}
if ($opp_rank<26 AND $Result=='L') {
$top25_L=$top25_L+1;
}
if ($opp_rank<65 AND $Result=='W') {
$top64_W=$top64_W+1;
}
if ($opp_rank<65 AND $Result=='L') {
$top64_L=$top64_L+1;
}

// if($col == '#cccccc') { $col = '#ffffff'; } else { $col = '#cccccc'; }

echo "

“;
if($col == ‘#cccccc’) { $col = ‘#ffffff’; } else { $col = ‘#cccccc’; }

}

// if (is_null($a52))
// {
// $opp_id = “99999″;
// }

// if ($opp_id<10000) {

}

echo "

“;

echo “Top 10 (W/L): “.$top10_W.”-”.$top10_L.”
“;
echo “Top 25 (W/L): “.$top25_W.”-”.$top25_L.”
“;
echo “Top 64 (W/L): “.$top64_W.”-”.$top64_L;

?>