$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"; echo "\t\t\n"; for ($i = 1; $i < $z; $i++){ echo "\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"; foreach($line as $col_value){ if($col_value!=$line[NTN]){ if($col_value==$line[Team]){ echo "\t\t\n"; } if($col_value!=$line[Team]){ echo "\t\t\n"; } $prev = $line[Games]; } // close IF statement } // close FOREACH statement } // close WHILE statement echo "\t\n"; echo "
\t\t\t\t\t\t$v[$i]\t\t
\t\t$rank\t\t\t\t$font$line[Team]\t\t\t\t$font$col_value\t\t
\n"; /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); ?>