NCAA College Football Live Computer Rankings

[insert_php]

$title=’NCAA Football LIVE Rankings’;
include(‘db/dbmysqli.php’);
include_once ‘db/common.php’;
$month = date(“m”);
$month > ‘1’ && date(“m”) < '8' ? $year = date("Y")-1: $year = date("Y"); echo '


First time here? Click here to understand the methodology used by the AMSTS Computer Rankings.

Historic rankings are available here.

League:     All    FBS    FCS     

These rankings update live every 15 minutes on Thursday at noon through Sunday morning at 3 AM Eastern. As teams score points in their game, their ranking will move up and down. As things happen in one game, other opponents may have their rankings affected as well! Read this post to see more details.
‘;

if(!isset($_GET[‘League’])){
$sql = “SELECT * from Live_NCAAF where Date=(select max(Date) from Live_NCAAF) and League = ‘FBS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘League’])==”FBS”){
$sql = “SELECT * from Live_NCAAF where Date=(select max(Date) from Live_NCAAF) and League = ‘FBS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘League’])==”FCS”){
$sql = “SELECT * from Live_NCAAF where Date=(select max(Date) from Live_NCAAF) and League = ‘FCS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘League’])==”All”){
$sql = “SELECT * from Live_NCAAF where Date=(select max(Date) from Live_NCAAF)
ORDER BY `Total Rank` ASC”;}
else{
$sql = “SELECT * from Live_NCAAF where Date=(select max(Date) from Live_NCAAF) and League = ‘FBS’
ORDER BY `Total Rank` ASC”;}

$result=mysqli_query($link,$sql);

if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){

$getID = mysqli_fetch_assoc($result);

$date = $getID[‘Date’];
mysqli_data_seek($result, 0);
echo ‘

Live Rankings as of (‘; echo $date; echo’):

‘;

if(($_GET[‘League’])==”All”){
echo’

‘;
}

else{
}

echo ‘

‘;

while($row = mysqli_fetch_array($result)){

$fd=$row[‘League’];
$f2=$row[‘Team’];
$f3=$row[‘Record’];
$f4=$row[‘Total Rating’];
$f7=$row[‘Win Rating’];
$f9=$row[‘Points Rating’];

$f2=utf8_encode($f2);

if(!isset($_GET[‘League’])){
$f1=$row[‘League Total Rank’];
$f5=$row[‘League Last Week’];
$f6=$row[‘League Difference’];
$f8=$row[‘League Win Rank’];
$f10=$row[‘League Points Rank’];
}

elseif(($_GET[‘League’])==”FBS”){
$f1=$row[‘League Total Rank’];
$f5=$row[‘League Last Week’];
$f6=$row[‘League Difference’];
$f8=$row[‘League Win Rank’];
$f10=$row[‘League Points Rank’];
}

elseif(($_GET[‘League’])==”FCS”){
$f1=$row[‘League Total Rank’];
$f5=$row[‘League Last Week’];
$f6=$row[‘League Difference’];
$f8=$row[‘League Win Rank’];
$f10=$row[‘League Points Rank’];
}

elseif(($_GET[‘League’])==”All”){
$f1=$row[‘Total Rank’];
$f5=$row[‘Last Week’];
$f6=$row[‘Difference’];
$f8=$row[‘Win Rank’];
$f10=$row[‘Points Rank’];
}

else{
$f1=$row[‘Total Rank’];
$f6=$row[‘Difference’];
$f8=$row[‘Win Rank’];
$f10=$row[‘Points Rank’];
}

$f2=’‘.$f2.’‘;
echo ‘

‘;

if(($_GET[‘League’])==”All”){
echo’

‘;
}

else{
}

echo ‘

‘;

$i++;
}

echo “

League Total Rank Team Record Overall Rating Last Week Difference Win Rating Win Rank Points Rating Points Rank
‘; echo $fd; echo ‘ ‘; echo $f1; echo ‘ ‘; echo $f2; echo ‘ ‘; echo $f3; echo ‘ ‘; echo $f4; echo ‘ ‘; echo $f5; echo ‘ ‘; echo $f6; echo ‘ ‘; echo $f7; echo ‘ ‘; echo $f8; echo ‘ ‘; echo $f9; echo ‘ ‘; echo $f10; echo ‘

“;
// Close result set
mysqli_free_result($result);
} else{
echo “No records matching your query were found.”;
}
} else{
echo “ERROR: Could not execute $sql. ” . mysqli_error($link);
}
[/insert_php]