$PageTitle - $SiteName\n"); print("\n"); print("

BTCC results

BTCC results

BTCC results Below you can access results from BTCC races.

Event Dates

\n"); $Query2 = "SELECT * FROM circuits WHERE CircuitID=$results[CircuitID]"; $Result2 = mysql_db_query ($DBName, $Query2, $Link); while ($results2 = mysql_fetch_array ($Result2)) { $Circuit = $results2[CircuitName]; } if ($results[SessionType] == "Race 1") { //Next line need schanging for seasons where races per round is NOT 3 $RndNo = ($results[MeetingID] * 3) - (3 - $results[RoundNo] ); $ID = $results[WinnerDrivID]; $ResultType = "Race 1 Result"; $RoundHTML = "- Round "."$RndNo "; $Desc = "Winner"; } elseif ($results[SessionType] == "Race 2") { //Next line need schanging for seasons where races per round is NOT 3 $RndNo = ($results[MeetingID] * 3) - (3 - $results[RoundNo] ); $ID = $results[WinnerDrivID]; $ResultType = "Race 2 Result"; $RoundHTML = "- Round "."$RndNo "; $Desc = "Winner"; } elseif ($results[SessionType] == "Race 3") { //Next line need schanging for seasons where races per round is NOT 3 $RndNo = ($results[MeetingID] * 3) - (3 - $results[RoundNo] ); $ID = $results[WinnerDrivID]; $ResultType = "Race 3 Result"; $RoundHTML = "- Round "."$RndNo "; $Desc = "Winner"; } elseif ($results[SessionType] == "Qual") { $ID = $results[PoleDrivID]; $ResultType = "Qualifying"; $RoundHTML = ""; $Desc = "Pole position"; } elseif ($results[SessionType] == "Prac 1") { $ID = $results[WinnerDrivID]; $ResultType = "Free Prac 1"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Prac 2") { $ID = $results[WinnerDrivID]; $ResultType = "Free Prac 2"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Test session 1") { $ID = $results[WinnerDrivID]; $ResultType = "Test session 1"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Test session 2") { $ID = $results[WinnerDrivID]; $ResultType = "Test session 2"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Test session 3") { $ID = $results[WinnerDrivID]; $ResultType = "Test session 3"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Test session 4") { $ID = $results[WinnerDrivID]; $ResultType = "Test session 4"; $RoundHTML = ""; $Desc = "Fastest lap"; } elseif ($results[SessionType] == "Combined classification") { $ID = $results[WinnerDrivID]; $ResultType = "Combined classification"; $RoundHTML = ""; $Desc = "Fastest lap"; } $Query3 = "SELECT * FROM people WHERE PersonID=$ID"; $Result3 = mysql_db_query ($DBName, $Query3, $Link); while ($results3 = mysql_fetch_array ($Result3)) { $Winner = "$results3[FirstName]"." "."$results3[LastName]"; } print ("

BTCC $results[Year] $RoundHTML - $Circuit

\n"); print ("

$ResultType $Desc: $Winner

\n"); print ("

\n"); print ("$ResultType\n"); print ("$results[RoundDate]\n"); print ("

\n"); print ("
\n"); } ?>