Softball league, Long Island NY - Long Island NY Softball team rankings

GetValue(); if (false == $hideRankings) { //ranks query 1-15 starts here: $maxRows_ranks = 15; $pageNum_ranks = 0; if (isset($HTTP_GET_VARS['pageNum_ranks'])) { $pageNum_ranks = $HTTP_GET_VARS['pageNum_ranks']; } $startRow_ranks = $pageNum_ranks * $maxRows_ranks; mysql_select_db($database_island, $island); $query_ranks = "SELECT * FROM ranking ORDER BY points DESC"; $query_limit_ranks = sprintf("%s LIMIT %d, %d", $query_ranks, $startRow_ranks, $maxRows_ranks); $ranks = mysql_query($query_limit_ranks, $island) or die(mysql_error()); $row_ranks = mysql_fetch_assoc($ranks); if (isset($HTTP_GET_VARS['totalRows_ranks'])) { $totalRows_ranks = $HTTP_GET_VARS['totalRows_ranks']; } else { $all_ranks = mysql_query($query_ranks); $totalRows_ranks = mysql_num_rows($all_ranks); } $totalPages_ranks = ceil($totalRows_ranks/$maxRows_ranks)-1; //ranks query for teams and divisions starts here: mysql_select_db($database_island, $island); $query_divb = "SELECT * FROM ranking WHERE division = 'B' ORDER BY points DESC"; $divb = mysql_query($query_divb, $island) or die(mysql_error()); $row_divb = mysql_fetch_assoc($divb); $totalRows_divb = mysql_num_rows($divb); mysql_select_db($database_island, $island); $query_divc = "SELECT * FROM ranking WHERE division = 'C' ORDER BY points DESC"; $divc = mysql_query($query_divc, $island) or die(mysql_error()); $row_divc = mysql_fetch_assoc($divc); $totalRows_divc = mysql_num_rows($divc); mysql_select_db($database_island, $island); $query_divd = "SELECT * FROM ranking WHERE division = 'D' ORDER BY points DESC"; $divd = mysql_query($query_divd, $island) or die(mysql_error()); $row_divd = mysql_fetch_assoc($divd); $totalRows_divd = mysql_num_rows($divd); mysql_select_db($database_island, $island); $query_dive = "SELECT * FROM ranking WHERE division = 'E' ORDER BY points DESC"; $dive = mysql_query($query_dive, $island) or die(mysql_error()); $row_dive = mysql_fetch_assoc($dive); $totalRows_dive = mysql_num_rows($dive); } ?> Softball league, Long Island NY - Long Island NY Softball team rankings

Ranking

"); $bgcolor = 2; } else { echo (""); $bgcolor = 1; } ?>

Team Name		Pts

Rank by Division

"); $bgcolor = 2; } else { echo (""); $bgcolor = 1; } ?>

Division B
	Team Name	Pts

"); $bgcolor1 = 2; } else { echo (""); $bgcolor1 = 1; } ?>

Division C
	Team Name	Pts

"); $bgcolor2 = 2; } else { echo (""); $bgcolor2 = 1; } ?>

Division D
	Team Name	Pts

"); $bgcolor3 = 2; } else { echo (""); $bgcolor3 = 1; } ?>

CO ED Division
	Team Name	Pts

Please check back every Monday for the top 15 teams in the Island Slowpitch Leagues.