Standings-Test

ID;

$S_ID = 6;

$sql = “SELECT * FROM events e INNER JOIN series s ON s.Series_ID = e.Series_ID WHERE e.Series_ID = $S_ID AND e.Results_Uploaded = 1 ORDER BY Event_ID DESC LIMIT 1”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 18.”);
$num = mysql_num_rows($result);

if($num==0)
{ ?> This page will be viewable after race results are processed!


After

0 AND dd.Series_ID = $S_ID ORDER BY ds.ds_Total_Pts DESC LIMIT 13″;
$result = mysql_query($sql)
or die(“Couldn’t execute query 147.”);
while ($row = mysql_fetch_array($result))
{
extract($row);
}

$sql = “SELECT * FROM driver_stats ds INNER JOIN drivers d ON d.Driver_ID = ds.Driver_ID INNER JOIN driver_detail dd ON dd.Driver_ID = ds.Driver_ID WHERE ds.Series_ID = $S_ID AND ds.ds_Total_Pts > 0 AND dd.Series_ID = $S_ID ORDER BY ds.ds_Total_Pts DESC, ds.ds_Wins DESC, ds.ds_T5 DESC, ds.ds_T10 DESC, ds.ds_Laps_Led DESC”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 147.”);
while ($row = mysql_fetch_array($result))
{
extract($row);

$BPts = $ds_BPts_Win + $ds_BPts_Laps + $ds_BPts_MLaps + $ds_BPts_Inc;
$PPts = $ds_BPts_IncN + $ds_PPts;
$Pos++;

$Behind = $ds_Total_Pts – $Leader;
$BChase = $ds_Total_Pts – $Chase_Cut;

$Change = $ds_Prev – $ds_Current;

if($Change==”0″)
{
$Change = “-“;
}

if($Change>0)
{
$Change = “+” . $Change;
}

if($Pos==”1″)
{
$Leader = $ds_Total_Pts;
$Behind = “-“;
}

if($Prev_Pts==$ds_Total_Pts)
{
$DPos = “-“;
}
else
{
$DPos = $Pos;
}

$Prev_Pos = $DPos;
$Prev_Pts = $ds_Total_Pts;

if($Pos <= 12) { $BChase = $ds_Total_Pts - $Thirtheenth; $Chase_Cut = $ds_Total_Pts; if($Chase_Active==0) { ?>

12)
{

if($Chase_Active==0)
{
?>

Pos

Chg

Num

Driver

Starts

Wins

Top 5

Top 10

Pts

Bns

Pen

Led

Inc

+/- Chs

Bh Ldr