NCAA College Basketball Rankings


[insert_php]
include(‘db/dbmysqli.php’);
echo ‘



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

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

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

Historic rankings are available here.

‘;
$sql = “SELECT * from NCAA_Basketball where Date=(select max(Date) from NCAA_Basketball)
ORDER BY `Total Rank` ASC”;

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’):

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

$f1=$row[‘Total Rank’];
$f2=$row[‘Team’];
$f3=$row[‘Record’];
$f4=$row[‘Total Rating’];
$f5=$row[‘Last Week’];
$f6=$row[‘Difference’];
$f7=$row[‘Win Rating’];
$f8=$row[‘Win Rank’];
$f9=$row[‘Points Rating’];
$f10=$row[‘Points Rank’];

$f2=utf8_encode($f2);

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

‘;
}
echo “

Overall Rank Team Record Overall Rating Last Week Difference Win Rating Win Rank Points Rating Points Rank
‘; 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);
mysqli_close($link);
} else{
echo “No records matching your query were found.”;
}
} else{
echo “ERROR: Could not execute $sql. ” . mysqli_error($link);
}

[/insert_php]