include("nationwide_schedule_for_index.php"); ?>
2014 P10 Nationwide Standings
Pos |
Name |
Points |
include ("db.php");
$query = 'SELECT * , sum( points ) , count( week ) , min( points ) , max( points ) FROM `SeasonTotals` GROUP BY name ORDER BY `sum( points )` DESC LIMIT 10 ';
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
$rname=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"sum( points )");
$extra=1 ;
$pos=$i+$extra ;
?>
echo "$pos"; ?> |
echo "$rname"; ?> |
echo "$points"; ?> |
++$i;
}
echo " ";
?>
Complete Standings
|
echo "Week $weekno " ; ?> echo "$weekrace Winner:" ; ?>
echo "$weekwinner" ; ?>
Complete Results
|
echo "$p10recap" ; ?>
include("top5nwthisweek.php");
?> |
BY THE NUMBERS:
include("winner-mll.php") ;
$chk1st=$tfirst;
$chkmll=$tmll;
include ("db.php");
$check="SELECT * FROM 2014main WHERE week=$weekno AND 1st=$chk1st ";
$resultchk=mysql_query($check);
$fnum=mysql_numrows($resultchk);
$checkmll="SELECT * FROM 2014main WHERE week=$weekno AND mll=$chkmll ";
$resultmll=mysql_query($checkmll);
$fnumx=mysql_numrows($resultmll);
mysql_close();
echo "- $fnum members selected #$chk1st to finish first.
" ;
echo "- $fnumx members selected #$chkmll to lead the most laps.
" ;
?>
- High Weekly Score for 2014:
include("nwtopweekscore-season.php"); ?>
|
|
|
echo "$weekrace" ; ?>
echo "$headline" ; ?>
Results
include ("db.php"); /*database connection and error trapping */
$query = "SELECT * FROM `2014finalresults` WHERE week=$weekno ORDER BY `fin` ASC ";
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
$fin=mysql_result($result,$i,"fin");
//$st=mysql_result($result,$i,"st");
$car=mysql_result($result,$i, "car");
$driver=mysql_result($result,$i, "driver");
$make=mysql_result($result,$i, "make");
$laps=mysql_result($result,$i, "laps");
//$status=mysql_result($result,$i, "status");
?>
echo "$fin"; ?> |
echo "$car"; ?> |
echo "$driver"; ?> |
++$i;
}
echo " ";
?>
|