NCAA College Football Rankings


[insert_php]

$title=’NCAA Football 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.

During the season, view the live rankings, which update every 15 minutes while a game is going on, by clicking here

Historic rankings are available here.

Division:     All    FBS    FCS     

‘;

if(!isset($_GET[‘league’])){
$sql = “SELECT * from NCAA_Football where Date=(select max(Date) from NCAA_Football) and League = ‘FBS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘league’])==”FBS”){
$sql = “SELECT * from NCAA_Football where Date=(select max(Date) from NCAA_Football) and League = ‘FBS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘league’])==”FCS”){
$sql = “SELECT * from NCAA_Football where Date=(select max(Date) from NCAA_Football) and League = ‘FCS’
ORDER BY `Total Rank` ASC”;}
elseif(($_GET[‘league’])==”All”){
$sql = “SELECT * from NCAA_Football where Date=(select max(Date) from NCAA_Football)
ORDER BY `Total Rank` ASC”;}
else{
$sql = “SELECT * from NCAA_Football where Date=(select max(Date) from NCAA_Football) 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’];
$week = $getID[‘week’];
mysqli_data_seek($result, 0);
echo ‘

Week ‘; echo $week; echo ‘ Rankings (‘; 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 Overall 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]