$GAMETI Played In $YEAR"; include "header.htm"; ?>
$GAMEUP TOP 100 FINISHES | ";
?>
NTN has assigned the name BUFWLDWNGS to more than one location in several cities including:
";
print"Cincinnati, Columbus, Evansville, Houston, Minneapolis, Omaha, and Richmond. Disregard that data.
";
}
$YR = substr($YEAR,2,2);
$YR = "'%".$YR."'";
// list of names for days and months
$months=array("","","January","February","March","April","May","June","July",
"August","September","October","November","December");
/* Connecting, selecting database */
if($GAMELO!='qb1'){
$link = mysql_connect("mysql1304.ixwebhosting.com", "denton_ntn", "sQ2975") or die("Could not connect");
mysql_select_db("denton_ntn") or die("Could not select database");
}else{
if($YEAR==2004){
$database="denton_qb1";
}else{
$database="denton_qb".$YEAR;
}
$link = mysql_connect("mysql1304.ixwebhosting.com", "denton_qb1", "sQ2975") or die("Could not connect");
mysql_select_db($database) or die("Could not select database");
}
// Get latest file name
$query = "SELECT MAX(File) AS Latest FROM $GAMELO WHERE File LIKE $YR GROUP BY File";
$result = mysql_query($link, $query) or die("Weekly Scores Query failed");
while ($line = mysql_fetch_assoc($result)) {
$latest = $line[Latest];
}
$mo = substr($latest,2,2);
$da = substr($latest,4,2);
$yr = substr($latest,6,2)+2000;
$games = $months[1+$mo];
echo "
Includes scores from the $games $da, $yr game.
";
echo"Click on team name to see how they've done this year.
";
mysql_free_result($result);
//----------
if($YEAR>2004){
$query = "SELECT NTN, Team, City, SP, COUNT(DISTINCT File) AS Games FROM $GAMELO WHERE File LIKE $YR AND Rank*1<=100 GROUP BY ID ORDER BY Games DESC,NTN";
}else{
$query = "SELECT NTN, Team, City, SP, COUNT(DISTINCT File) AS Games FROM $GAMELO WHERE File LIKE $YR AND Rank*1<=100 GROUP BY NTN ORDER BY Games DESC,NTN";
}
if($GAMELO=="qb1"){
if($YEAR==2004){
$query = "SELECT NTN, Team, City, SP, COUNT(DISTINCT CONCAT(File,ID)) AS Games FROM $GAMELO WHERE File LIKE $YR AND Rank*1<=100 GROUP BY ID ORDER BY Games DESC,NTN";
}else{
$query = "SELECT NTN, Team, City, SP, COUNT(DISTINCT CONCAT(File,GameID)) AS Games FROM $GAMELO WHERE File LIKE $YR AND Rank*1<=100 GROUP BY ID ORDER BY Games DESC,NTN";
}
}
$result = mysql_query($link, $query) or die("Query failed");
/* echoing results in HTML */
$z = mysql_num_fields($result);
for ($i = 1; $i < $z; $i++){
$v[$i] = mysql_field_name ($result, $i);
$v[$i]= strtoupper($v[$i]);
}
echo "\n";
echo "\t
\n";
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
?>
\n";
echo "\t\t \t\t \t\t \n";
for ($i = 1; $i < $z; $i++){
echo "\t\t\t\t $v[$i] \t\t \n";
}
$prev = 0;
$last = 0;
$i=0;
while ($line = mysql_fetch_assoc($result)) {
$i++;
echo "\t\n";
if ($line[Games] == $prev) {$rank = $last;} else{ $rank = $i;}
$last = $rank;
$font="";
$site=$line[Team].$line[City].$line[SP];
if($YEAR<2005){
switch ($site) {
case "BUFWLDWNGSHOUSTONTX":
case "BUFWLDWNGSCINCINNATIOH":
case "BUFWLDWNGSRICHMONDVA":
case "BUFWLDWNGSMINNEAPOLIMN":
case "BUFWLDWNGSEVANSVILLEIN":
case "BUFWLDWNGSOMAHANE":
case "BUFWLDWNGSCOLUMBUSOH":
$font="";
break;
}
}
$NTN=urlencode($line[NTN]);
$YEAR=$yr;
echo "\t\t \n";
echo "\t\t $rank \t\t \n";
foreach($line as $col_value){
if($col_value!=$line[NTN]){
if($col_value==$line[Team]){
echo "\t\t\t\t $font$line[Team] \t\t \n";
}
if($col_value!=$line[Team]){
echo "\t\t\t\t $font$col_value \t\t \n";
}
$prev = $line[Games];
} // close IF statement
} // close FOREACH statement
} // close WHILE statement
echo "\t