Sports411.com Fantasy Sports Games Zone

= '$gp' AND pts >= '$pts' AND reb >= '$reb' AND ast >= '$ast' AND stl >= '$stl' AND blk >= '$blk' ORDER BY $sort $sortType"; } else { $querySelectAll = "SELECT * FROM $table WHERE (pos1='$pos' OR pos2='$pos' OR pos3='$pos' OR pos4='$pos' OR pos5='$pos') AND gp >= '$gp' AND pts >= '$pts' AND reb >= '$reb' AND ast >= '$ast' AND stl >= '$stl' AND blk >= '$blk' ORDER BY $sort $sortType"; } $result = MySQL_query($querySelectAll, $link); $total = mysql_num_rows($result); if(!$offset) { $offset = 0; } elseif($offset >= $total) { $offset = $total - $limit; } $result = mysql_query("$querySelectAll limit $offset, $limit", $link); While( $rows = MySQL_fetch_array($result) ) { $id = $rows[0]; $playerName = $rows[2]." ".$rows[1]; $team = $rows[3]; $pos1 = $rows[4]; $pos2 = $rows[5]; $pos3 = $rows[6]; $pos4 = $rows[7]; $pos5 = $rows[8]; $salary = $rows[9]; $g = $rows[10]; $pts = $rows[11]; $reb = $rows[12]; $ast = $rows[13]; $stl = $rows[14]; $blk = $rows[15]; $fpts = $rows[16]; $fpg = $rows[17]; $salary = dollar_format($salary); if ($count == $repeatHeader) { ?>

Fantasy Basketball
Coming Fall 2006

Regular Season:

0) { getPages($season, $playerName, $pos, $sort, $sortType, $offset, $limit); } ?>

Name
Sort First:

Last:

Team

Position

Pts

Reb

Ast

Stl

Blk

Fpts

FP/G

Search returned no results.

0) { getPages($season, $playerName, $pos, $sort, $sortType, $offset, $limit); } ?>

0) { $prevUrl = "[ prev ] "; } else { $prev = $offset - $limit; $prevUrl = "[ prev ]"; } // create link to next page $next = $offset + $limit; if($next >= $total) { $nextUrl = "[ next ]"; } else { $nextUrl = "[ next ]"; } echo "

$prevUrl "; // print page links $numberOfPages = ceil($total / $limit); for($i=0; $i<$numberOfPages; $i++) { if($i * $limit == $offset) { print "".($i + 1)." "; } else { print "".($i + 1)." "; } } print $nextUrl; } function countPlayers($season, $playerName, $pos) { $table = "basketball_".$season; $link = dbConnect(); if ($pos == "--") { $querySelectAll = "SELECT COUNT(*) FROM $table WHERE lname LIKE '%$playerName%' OR fname LIKE '%$playerName%'"; } else { $querySelectAll = "SELECT COUNT(*) FROM $table WHERE (lname LIKE '%$playerName%' OR fname LIKE '%$playerName%') AND (pos1='$pos' OR pos2='$pos' OR pos3='$pos' OR pos4='$pos' OR pos5='$pos')"; } $result = MySQL_query($querySelectAll, $link); $rows = MySQL_fetch_array($result); return $rows[0]; } function countCalc($season, $pos, $gp, $pts, $reb, $ast, $stl, $blk) { $table = "basketball_".$season; $link = dbConnect(); if ($pos == "--") { $querySelectAll = "SELECT COUNT(*) FROM $table WHERE AND gp >= '$gp' AND pts >= '$pts' AND reb >= '$reb' AND ast >= '$ast' AND stl >= '$stl' AND blk >= '$blk'"; } else { $querySelectAll = "SELECT COUNT(*) FROM $table WHERE (pos1='$pos' OR pos2='$pos' OR pos3='$pos' OR pos4='$pos' OR pos5='$pos') AND gp >= '$gp' AND pts >= '$pts' AND reb >= '$reb' AND ast >= '$ast' AND stl >= '$stl' AND blk >= '$blk'"; } $result = MySQL_query($querySelectAll, $link); $rows = MySQL_fetch_array($result); return $rows[0]; } function getPlayers($season, $playerName, $pos, $sort, $sortType, $numResults, $limit, $offset) { $table = "basketball_".$season; $count = 0; $repeatHeader = 10; //How many listings before repeating table header $white = true; $link = dbConnect(); if ($pos == "--") { $querySelectAll = "SELECT * FROM $table WHERE lname LIKE '%$playerName%' OR fname LIKE '%$playerName%' ORDER BY $sort $sortType"; } else { $querySelectAll = "SELECT * FROM $table WHERE (lname LIKE '%$playerName%' OR fname LIKE '%$playerName%') AND (pos1='$pos' OR pos2='$pos' OR pos3='$pos' OR pos4='$pos' OR pos5='$pos') ORDER BY $sort $sortType"; } $result = MySQL_query($querySelectAll, $link); $total = mysql_num_rows($result); if(!$offset) { $offset = 0; } elseif($offset >= $total) { $offset = $total - $limit; } $result = mysql_query("$querySelectAll limit $offset, $limit", $link); While( $rows = MySQL_fetch_array($result) ) { $id = $rows[0]; $playerName = $rows[2]." ".$rows[1]; $team = $rows[3]; $pos1 = $rows[4]; $pos2 = $rows[5]; $pos3 = $rows[6]; $pos4 = $rows[7]; $pos5 = $rows[8]; $salary = $rows[9]; $g = $rows[10]; $pts = $rows[11]; $reb = $rows[12]; $ast = $rows[13]; $stl = $rows[14]; $blk = $rows[15]; $fpts = $rows[16]; $fpg = $rows[17]; $salary = dollar_format($salary); if ($count == $repeatHeader) { ?>

Name

Team

Position

Pts

Reb

Ast

Stl

Blk

Fpts

FP/G

width="20">

Name

Team

Position

Pts

Reb

Ast

Stl

Blk

Fpts

FP/G

width="20">