include("indexedit.php") ;
list($width, $height, $type, $attr) = getimagesize("2014/$weekno/race_winner_sm.gif");
list($twidth, $theight, $ttype, $tattr) = getimagesize("2014/$weekno/race_winner_sm.gif");
?>
Nascar Fantasy Racing - P10 Select
2018 P10 Select Rookie Standings
Pos |
Name |
Points |
Weeks |
Min Score |
Max Score |
include("db.php");
//mysql_connect("localhost",$username,$password);
//@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * , sum( points ) , count( week ) , min( points ) , max( points ) FROM `SeasonTotals`
WHERE name='MadDog Racing' OR name='HYDRO' OR name='CaptainBert' OR name='HuskerMagic'
OR name='til5022' OR name='Cheviot Motorsports' OR name='17KJ' OR name='mattfantom1'
OR name='nathaniel_c20'
GROUP BY name ORDER BY `sum( points )` DESC " ;
$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 )");
$weeks=mysql_result($result,$i, "count( week )");
$min=mysql_result($result,$i, "min( points )");
$max=mysql_result($result,$i, "max( points )");
$extra=1 ;
$pos=$i+$extra ;
?>
echo "$pos"; ?> |
echo "$rname"; ?> |
echo "$points"; ?> |
echo "$weeks"; ?> |
echo "$min"; ?> |
echo "$max"; ?> |
++$i;
}
echo "
";
?>