<?php 
function tfm_cleanOrderBy($theValue, $defaultSort) {
	if (preg_match("/^[\w,]{1,50}\s+(asc|desc)\s*$/i",$theValue, $matches)) {
		return $matches[0];
	}
	return $defaultSort;
}
?><?php require_once('../Connections/connvbsa.php'); ?>
<?php
$tfm_orderby =(!isset($_GET["tfm_orderby"]))?"team_id":$_GET["tfm_orderby"];
$tfm_order =(!isset($_GET["tfm_order"]))?"ASC":$_GET["tfm_order"];
$sql_orderby = $tfm_orderby." ".$tfm_order;
$sql_orderby = tfm_cleanOrderBy($sql_orderby, "team_id");
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

//TOMLR Special List Recordset
// Defining List Recordset variable
$sqlorderby_team_entries = "team_id";
if (isset($sql_orderby)) {
  $sqlorderby_team_entries = $sql_orderby;
}
mysql_select_db($database_connvbsa, $connvbsa);

$query_team_entries = "SELECT * FROM Team_entries ORDER BY {$sqlorderby_team_entries}";
$team_entries = mysql_query($query_team_entries, $connvbsa) or die(mysql_error());
$row_team_entries = mysql_fetch_assoc($team_entries);
$totalRows_team_entries = mysql_num_rows($team_entries);
//End TOMLR Special List Recordset

mysql_select_db($database_connvbsa, $connvbsa);
$query_A_Biil_Count = "SELECT COUNT(*) AS TotalABill FROM Team_entries WHERE team_grade = 'A_Prem_Billiards' ";
$A_Biil_Count = mysql_query($query_A_Biil_Count, $connvbsa) or die(mysql_error());
$row_A_Biil_Count = mysql_fetch_assoc($A_Biil_Count);
$totalRows_A_Biil_Count = mysql_num_rows($A_Biil_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_B_Bill_Count = "SELECT COUNT(*) AS TotalBBill FROM Team_entries WHERE team_grade = 'B_Prem_Billiards'";
$B_Bill_Count = mysql_query($query_B_Bill_Count, $connvbsa) or die(mysql_error());
$row_B_Bill_Count = mysql_fetch_assoc($B_Bill_Count);
$totalRows_B_Bill_Count = mysql_num_rows($B_Bill_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_A_Will_Count = "SELECT COUNT(*) AS TotaAWill FROM Team_entries WHERE team_grade = 'A_Willis_Snooker'";
$A_Will_Count = mysql_query($query_A_Will_Count, $connvbsa) or die(mysql_error());
$row_A_Will_Count = mysql_fetch_assoc($A_Will_Count);
$totalRows_A_Will_Count = mysql_num_rows($A_Will_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_B_Will_Count = "SELECT COUNT(*) AS TotaBWill FROM Team_entries WHERE team_grade = 'B_Willis_Snooker'";
$B_Will_Count = mysql_query($query_B_Will_Count, $connvbsa) or die(mysql_error());
$row_B_Will_Count = mysql_fetch_assoc($B_Will_Count);
$totalRows_B_Will_Count = mysql_num_rows($B_Will_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_C_Will_Count = "SELECT COUNT(*) AS TotaCWill FROM Team_entries WHERE team_grade = 'C_Willis_Snooker'";
$C_Will_Count = mysql_query($query_C_Will_Count, $connvbsa) or die(mysql_error());
$row_C_Will_Count = mysql_fetch_assoc($C_Will_Count);
$totalRows_C_Will_Count = mysql_num_rows($C_Will_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_D_Will_Count = "SELECT COUNT(*) AS TotaDWill FROM Team_entries WHERE team_grade = 'D_Willis_Snooker'";
$D_Will_Count = mysql_query($query_D_Will_Count, $connvbsa) or die(mysql_error());
$row_D_Will_Count = mysql_fetch_assoc($D_Will_Count);
$totalRows_D_Will_Count = mysql_num_rows($D_Will_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_D_Res_Count = "SELECT COUNT(*) AS TotalDRes FROM Team_entries WHERE team_grade = 'D_Res_Snooker'";
$D_Res_Count = mysql_query($query_D_Res_Count, $connvbsa) or die(mysql_error());
$row_D_Res_Count = mysql_fetch_assoc($D_Res_Count);
$totalRows_D_Res_Count = mysql_num_rows($D_Res_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_C_Res_Count = "SELECT COUNT(*) AS TotalCRes FROM Team_entries WHERE team_grade = 'C_Res_Snooker'";
$C_Res_Count = mysql_query($query_C_Res_Count, $connvbsa) or die(mysql_error());
$row_C_Res_Count = mysql_fetch_assoc($C_Res_Count);
$totalRows_C_Res_Count = mysql_num_rows($C_Res_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_B_Res_Count = "SELECT COUNT(*) AS TotalBRes FROM Team_entries WHERE team_grade = 'B_Res_Snooker'";
$B_Res_Count = mysql_query($query_B_Res_Count, $connvbsa) or die(mysql_error());
$row_B_Res_Count = mysql_fetch_assoc($B_Res_Count);
$totalRows_B_Res_Count = mysql_num_rows($B_Res_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_A_Res_Count = "SELECT COUNT(*) AS TotalARes FROM Team_entries WHERE team_grade = 'A_Res_Snooker'";
$A_Res_Count = mysql_query($query_A_Res_Count, $connvbsa) or die(mysql_error());
$row_A_Res_Count = mysql_fetch_assoc($A_Res_Count);
$totalRows_A_Res_Count = mysql_num_rows($A_Res_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_Tot_Play_Positions = "SELECT SUM(players) AS TotPositions FROM Team_entries";
$Tot_Play_Positions = mysql_query($query_Tot_Play_Positions, $connvbsa) or die(mysql_error());
$row_Tot_Play_Positions = mysql_fetch_assoc($Tot_Play_Positions);
$totalRows_Tot_Play_Positions = mysql_num_rows($Tot_Play_Positions);

mysql_select_db($database_connvbsa, $connvbsa);
$query_Tot_Inc = "SELECT SUM(players*5*14) AS TotInc FROM Team_entries";
$Tot_Inc = mysql_query($query_Tot_Inc, $connvbsa) or die(mysql_error());
$row_Tot_Inc = mysql_fetch_assoc($Tot_Inc);
$totalRows_Tot_Inc = mysql_num_rows($Tot_Inc);

mysql_select_db($database_connvbsa, $connvbsa);
$query_A_Prem_Count = "SELECT COUNT(*) AS TotalAPrem FROM Team_entries WHERE team_grade = 'A_Prem_Snooker' ";
$A_Prem_Count = mysql_query($query_A_Prem_Count, $connvbsa) or die(mysql_error());
$row_A_Prem_Count = mysql_fetch_assoc($A_Prem_Count);
$totalRows_A_Prem_Count = mysql_num_rows($A_Prem_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_B_Prem_Count = "SELECT COUNT(*) AS TotalBPrem FROM Team_entries WHERE team_grade = 'B_Prem_Snooker' ";
$B_Prem_Count = mysql_query($query_B_Prem_Count, $connvbsa) or die(mysql_error());
$row_B_Prem_Count = mysql_fetch_assoc($B_Prem_Count);
$totalRows_B_Prem_Count = mysql_num_rows($B_Prem_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_C_Prem_Count = "SELECT COUNT(*) AS TotalCPrem FROM Team_entries WHERE team_grade = 'C_Prem_Count' ";
$C_Prem_Count = mysql_query($query_C_Prem_Count, $connvbsa) or die(mysql_error());
$row_C_Prem_Count = mysql_fetch_assoc($C_Prem_Count);
$totalRows_C_Prem_Count = mysql_num_rows($C_Prem_Count);

mysql_select_db($database_connvbsa, $connvbsa);
$query_D_Prem_Count = "SELECT COUNT(*) AS TotalDPrem FROM Team_entries WHERE team_grade = 'D_Prem_Count' ";
$D_Prem_Count = mysql_query($query_D_Prem_Count, $connvbsa) or die(mysql_error());
$row_D_Prem_Count = mysql_fetch_assoc($D_Prem_Count);
$totalRows_D_Prem_Count = mysql_num_rows($D_Prem_Count);
?>
<?php
//sort column headers for team_entries
$tfm_saveParams = explode(",","");
$tfm_keepParams = "";
if($tfm_order == "ASC") {
	$tfm_order = "DESC";
}else{
	$tfm_order = "ASC";
};
while (list($key,$val) = each($tfm_saveParams)) {
	if(isset($_GET[$val]))$tfm_keepParams .= ($val)."=".urlencode($_GET[$val])."&";	
	if(isset($_POST[$val]))$tfm_keepParams .= ($val)."=".urlencode($_POST[$val])."&";
}
$tfm_orderbyURL = $_SERVER["PHP_SELF"]."?".$tfm_keepParams."tfm_order=".$tfm_order."&tfm_orderby=";
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/VBSA_page.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>City Clubs About Us</title>
<!-- InstanceEndEditable -->
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryMenuBarHorizontalSite.css" rel="stylesheet" type="text/css" />
<link href="../CSS/VBSAindex.css" rel="stylesheet" type="text/css" />

<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<link href="../CSS/VBSA_Page.css" rel="stylesheet" type="text/css" />
<link href="../CSS/VBSA_Page_Template.css" rel="stylesheet" type="text/css" />
</head>
<body>


<div id="Wrapper"><!--Open Wrapper-->	

	<!--Header-->	
		<div id="header">
		<div class="LeftTopCnr"><a href="../index.html"><img src="../images/VBSA_template_images/TopL2.jpg" title="Home Page"/></a></div>
		<div class="RightTopCnr"><img src="../images/VBSA_template_images/TopR2.jpg"/></div>
		<div id="logo">Victorian Billiards &amp; Snooker Association Incorporated, & Affiliates</div>
        <div id="logo2">Representing & Developing Snooker & Billiards as a sport in Victoria.</div>
        <div id="SubHeader">Affiliates - Church Billiards, DVSA, Ex Servicemens 55 & Over, Maccabi Club, MSBA, RSL, Southern, SS&A Club Albury, Snooker & Billiards Associations</div>
	</div><!--Close Header-->
    
	<div id="LeftSide"><img src="../images/VBSA_template_images/LeftSide2.jpg" /></div>
	<div id="RightSide"><img src="../images/VBSA_template_images/RightSide2.jpg"/></div>


<div id="NavigationBar">
  <ul id="lubs" class="MenuBarHorizontal">
    <li><a href="../index.html">Home</a></li>
    <li><a href="#" class="MenuBarItemSubmenu">VBSA</a>
        <ul>
          <li><a href="weeklyresults.html">Scores &amp; Stats</a></li>
          <li><a href="Finals_Info_results.html">Finals Info, results</a></li>
          <li><a href="Team_Entry.html">Team Entry &amp; Info</a></li>
          <li><a href="fixtures/ClubsContactsGrounds.pdf" target="_blank">Clubs</a></li>
          <li><a href="ScoreSheet.pdf" target="_blank">Scoresheet</a></li>
          <li><a href="../VBSAindex.htm">Members Info</a></li>
          <li><a href="fixtures/FixClubsIndex.htm">Fixtures</a></li>
          <li><a href="../NAY.html" class="MenuBarItemSubmenu">Rankings</a>
              <ul>
                <li><a href="../Tournaments/09 Rankings/2009SnookRankSuggested.pdf">Snooker Rankings</a></li>
                <li><a href="../Tournaments/09 Rankings/2009BilliardRankings.pdf">Billiards Rankings</a></li>
                <li><a href="../Tournaments/09 Rankings/Explainrankings2008update.pdf" target="_blank">About Vic Rankings</a></li>
              </ul>
          </li>
          <li><a href="../ComingEvents/Calendar of Event_Current.pdf" target="_blank">Calendar of Events</a></li>
          <li><a href="../payments.htm">Make a Payment</a></li>
          <li><a href="../VBSA/VBSA Board Contacts.htm">Contact the VBSA</a></li>
          <li><a href="../VBSA/TheVBSA.htm">About the VBSA</a></li>
          <li><a href="../Archives/ArchiveIndex.htm">VBSA History (Archives)</a></li>
          <li><a href="#" class="MenuBarItemSubmenu">City Clubs</a>
              <ul>
                <li><a href="../CityClubs/CCindex.htm">Scores &amp; Info</a></li>
                <li><a href="../CityClubs/ScoreSheetCC.pdf" target="_blank">Score Sheet</a></li>
                <li><a href="../CityClubs/City_Clubs_Clubs.php">Clubs</a></li>
                <li><a href="../CityClubs/City_Clubs_contact.htm">Contact Us</a></li>
                <li><a href="../CityClubs/City_Clubs_about.htm">About Us</a></li>
              </ul>
          </li>
        </ul>
    </li>
    <li><a class="MenuBarItemSubmenu" href="#">Affiliates</a>
        <ul>
          <li><a href="#" class="MenuBarItemSubmenu">Church Billiards</a>
            <ul>
              <li><a href="../Churches/CHURCHindex.htm">Scores &amp; Handicaps</a></li>
              <li><a href="../Churches/ChurchScore.pdf" target="_blank">Score Sheet</a></li>
              <li><a href="../Churches/ChurchBill_Clubs.php">Clubs</a></li>
              <li><a href="../Churches/Churches_About.html">About Us</a></li>
              <li><a href="../Churches/Churches_Contact.html">Contact Us</a></li>
            </ul>
          </li>
          <li><a href="#" class="MenuBarItemSubmenu2">DVSA</a>
              <ul>
                <li><a href="../DVSA/DVSAindex.htm">Scores</a></li>
                <li><a href="../DVSA/DVSA_Clubs.php">Clubs</a></li>
                <li><a href="../DVSA/DVSAScoresheet.pdf" target="_blank">Scoresheet</a></li>
                <li><a href="../DVSA/DVSA_Contact.html">Contact the DVSA</a></li>
                <li><a href="../DVSA/DVSA_About.html">About the DVSA</a></li>
            </ul>
          </li>
          <li><a href="#" class="MenuBarItemSubmenu2">MSBA</a>
              <ul>
                <li><a href="../MSBA/MSBAindex.htm">Scores</a></li>
                <li><a href="../MSBA/MSBA_Clubs.php" target="_blank">Clubs</a></li>
                <li><a href="../MSBA/Snooker Score Sheet - 2010.pdf" target="_blank">Scoresheet</a></li>
                <li><a href="../MSBA/MSBA_Contact.html">Contact MSBA</a></li>
                <li><a href="../MSBA/MSBA_About.html">About MSBA</a></li>
              </ul>
          </li>
          <li><a href="#" class="MenuBarItemSubmenu2">Over 55's</a>
              <ul>
                <li><a href="../Over 55s/Over55index.htm">Scores</a></li>
                <li><a href="../Over 55s/Over55_Clubs.php">Clubs</a></li>
                <li><a href="../Over 55s/Over55_contact.htm">Contact Over 55's</a></li>
                <li><a href="../Over 55s/Over55_about.htm">About Over 55's</a></li>
              </ul>
          </li>
          <li><a href="#" class="MenuBarItemSubmenu2">RSL</a>
              <ul>
                <li><a href="../RSL/RSLindex.htm">Scores</a></li>
                <li><a href="../RSL/Venues &amp; Contacts.pdf" target="_blank">Clubs</a></li>
                <li><a href="../RSL/Score sheet.pdf" target="_blank">Scoresheet</a></li>
                <li><a href="../RSL/RSL_Contact.html">Contact RSL</a></li>
                <li><a href="../RSL/RSL_About.html">About RSL</a></li>
              </ul>
          </li>
          <li><a href="../Southern/SouthernIndex.htm" class="MenuBarItemSubmenu2">Southern</a>
              <ul>
                <li><a href="../Southern/SouthernIndex.htm">Scores</a></li>
                <li><a href="../Southern/Southern_Clubs.php">Clubs</a></li>
                <li><a href="../Southern/SnookerScoreSheet2009.pdf" target="_blank">Scoresheet - Snooker</a></li>
                <li><a href="../Southern/BilliardsScoreSheet.pdf" target="_blank">Scoresheet - Billiards</a></li>
                <li><a href="../Southern/Southern_about.htm">About Southern</a></li>
                <li><a href="../Southern/Southern_contact.htm">Contact Southern</a></li>
              </ul>
          </li>
        </ul>
    </li>
    <li><a href="#" class="MenuBarItemSubmenu">Juniors</a>
        <ul>
          <li><a href="../NAY.html">Junior Pathways</a></li>
          <li><a href="../Tournaments/National Juniors/2009_AJC_Results.pdf" target="_blank">Junior Championships</a></li>
        </ul>
    </li>
    <li><a href="../VBSA/AccredCoach.htm">Coaching</a></li>
    <li><a href="#" class="MenuBarItemSubmenu">Referees</a>
        <ul>
          <li><a href="../Referees/RefereeIndex.htm">Referee Info</a></li>
          <li><a href="../Referees/Vic Qual Refs.htm">Qualified Referees</a></li>
          <li><a href="../Referees/RefereeContact.htm">Referees Contact</a></li>
        </ul>
    </li>
    <li><a href="#" class="MenuBarItemSubmenu">Tournaments</a>
      <ul>
        <li><a href="../Tournaments/tournindex.htm">Tournament Results</a></li>
        <li><a href="../Tournaments/2009_Tournament_Entry.pdf" target="_blank">Tournament Entry</a></li>
        <li><a href="../Archives/ArchiveIndex.htm">Tournament History</a></li>
        <li><a href="../Tournaments/Tournament_Entry_Conditions.html">Tournament entry conditions</a></li>
        <li><a href="#" class="MenuBarItemSubmenu">Check your tournament Entry &amp; Information</a>
          <ul>
            <li><a href="../Tournaments/COM/tournent_COM2.php">City of Melb</a></li>
            <li><a href="../Tournaments/FO/FO.html">Fred Osbourne</a></li>
            <li><a href="../Tournaments/HandicapTournaments/GC/tournent_hcap_GC.php">Gary Cullen Hcap</a></li>
            <li><a href="../Tournaments/HandicapTournaments/GG/tournent_hcap_GG_2.php">George Ganim Hcap</a></li>
            <li><a href="../Tournaments/HandicapTournaments/J Mc Kay/tournent_hcap_JMcK2.php">John Mc Kay Hacap</a></li>
            <li><a href="../Tournaments/HandicapTournaments/RF/tournent_hcap_RF2.php">Rob Foldvari Hcap</a></li>
            <li><a href="../Tournaments/Juniors/tournent_Vic_Jun_Billiards2.php">Vic Junior Billiards</a></li>
            <li><a href="../Tournaments/Juniors/tournent_Vic_Jun_Snooker2.php">Vic Junior Snooker</a></li>
            <li><a href="../Tournaments/KingsCup/KingsCup.php">Kings Cup</a></li>
            <li><a href="../Tournaments/LP/LancePannell.php">Lance Pannell</a></li>
            <li><a href="../Tournaments/Nat Billiards/Aust_Bill_entries.php">Aust Billiards</a></li>
            <li><a href="../Tournaments/Nat Snooker/tournent_Aust_Nat_Snooker2.php">Aust Snooker</a></li>
            <li><a href="../Tournaments/National Juniors/Nat_Juniors.html">Aust Juniors</a></li>
            <li><a href="../Tournaments/Pot Black/Pot Black.php">Pot Black</a></li>
            <li><a href="../Tournaments/PrincesCup/PrincesCup.php">Princes Cup</a></li>
            <li><a href="../Tournaments/SSA Classic/SSA.html">SS&amp;A Minor Classic</a></li>
            <li><a href="../Tournaments/VicBilliards/tournent_VicBill_2.php">Vic Billiards</a></li>
            <li><a href="../Tournaments/VicSnooker/tournent_Vic_Snooker2.php">Vic Snooker (Mens &amp; Womens)</a></li>
          </ul>
          </li>
      </ul>
      </li>
    <li><a href="../Links.htm">Links</a></li>
    <li><a href="#" class="MenuBarItemSubmenu">Help</a>
      <ul>
        <li><a href="../VBSA_Help/VBSA_Help.html">General Help Items and information about the game</a></li>
      </ul>
      </li>
  </ul>
</div>  <!--Close Navigation Bar--> 

	<!--Content-->	
<div id="Content">

<div id="PageContent"><!-- InstanceBeginEditable name="PageContent" -->
    <center>
    <div class="page">
  <div class="News_item">VBSA 2010 Pennant Season Team Entry Form &amp; Information <a href="ThisSeason/Penn Team Info 2010.pdf" target="_blank">.pdf format</a> or <a href="ThisSeason/Penn Team Info 2010.doc" target="_blank">word format</a>. Team entries close on 8th Feb and the season will start on Monday the 22nd Feb. Need to know if players would like to see the re-introduction of a 6 man D premier competion ? 2010 Membership form <a href="ThisSeason/Membership 1 2010.pdf" target="_blank">.pdf format</a> or <a href="ThisSeason/Membership 1 2010.doc" target="_blank">word format</a></div></div>
    <p>&nbsp;</p>
    <div id="page_header">Team Entries - Pennant</div>
    <div id="page_text"><?php echo $totalRows_team_entries ?> Teams in total</div>
    <table width="800">
  <tr>
    <th width="200">Monday</th>
    <th width="200">Total Teams</th>
    <th width="200">Wednesday</th>
    <th width="200">Total Teams</th>
  </tr>
  <tr>
    <td>A Reserve Snooker</td>
    <td><?php echo $row_A_Res_Count['TotalARes']; ?></td>
    <td>A Premier Snooker</td>
    <td><?php echo $row_A_Prem_Count['TotalAPrem']; ?></td>
  </tr>
  <tr>
    <td>B Premier Snooker</td>
    <td><?php echo $row_B_Prem_Count['TotalBPrem']; ?></td>
    <td>B Reserve Snooker</td>
    <td><?php echo $row_B_Res_Count['TotalBRes']; ?></td>
  </tr>
  <tr>
    <td>C Reserve Snooker</td>
    <td><?php echo $row_C_Res_Count['TotalCRes']; ?></td>
    <td>C Premier Snooker</td>
    <td><?php echo $row_C_Prem_Count['TotalCPrem']; ?></td>
  </tr>
  <tr>
    <td>D Reserve Snooker</td>
    <td><?php echo $row_D_Res_Count['TotalDRes']; ?></td>
    <td>D Premier Snooker</td>
    <td><?php echo $row_D_Prem_Count['TotalDPrem']; ?></td>
  </tr>
</table>
<p>&nbsp;</p>
<div id="page_text">To sort - click on the column header table will sort ascending, click again will sort descending</div>
<table width="800">
  <tr>
    <td><a href="<?Php echo ($tfm_orderbyURL); ?>team_club">Club</a></td>
    <td><a href="<?Php echo ($tfm_orderbyURL); ?>team_name">Team Name</a></td>
    <td><a href="<?Php echo ($tfm_orderbyURL); ?>team_grade">Grade</a></td>
    <td><a href="<?Php echo ($tfm_orderbyURL); ?>day_played">Day</a></td>
    <td><a href="<?Php echo ($tfm_orderbyURL); ?>players">Players</a></td>
  </tr>
  <?php do { ?>
    <tr>
      <td>
          <input name="hiddenField" type="hidden" id="hiddenField" value="<?php echo $row_Team_entries['team_ID']; ?>" />
          <?php echo $row_team_entries['team_club']; ?></td>
      <td><?php echo $row_team_entries['team_name']; ?></td>
      <td><?php echo $row_team_entries['team_grade']; ?></td>
      <td><?php echo $row_team_entries['day_played']; ?></td>
      <td><?php echo $row_team_entries['players']; ?></td>
    </tr>
    <?php } while ($row_team_entries = mysql_fetch_assoc($team_entries)); ?>
</table>
</center>
<!-- InstanceEndEditable -->    </div> 
<!--Close PageContentContent--> 
    
</div>    <!--Close Content--> 

	<!--Footer (Border Bottom)-->	
<div id="Footer">
<div class="LeftBottCnr"><img src="../images/VBSA_template_images/LeftBottCnr.jpg"/></div>
<div class="RightBottCnr"><img src="../images/VBSA_template_images/RightBottCnr.jpg" /></div>    
</div>   <!--Close Footer--> 
		

</div> <!--Close Wrapper-->    

<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("lubs", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($team_entries);

mysql_free_result($A_Biil_Count);

mysql_free_result($B_Bill_Count);

mysql_free_result($A_Will_Count);

mysql_free_result($B_Will_Count);

mysql_free_result($C_Will_Count);

mysql_free_result($D_Will_Count);

mysql_free_result($D_Res_Count);

mysql_free_result($C_Res_Count);

mysql_free_result($B_Res_Count);

mysql_free_result($A_Res_Count);

mysql_free_result($Tot_Play_Positions);

mysql_free_result($Tot_Inc);

mysql_free_result($A_Prem_Count);

mysql_free_result($B_Prem_Count);

mysql_free_result($C_Prem_Count);

mysql_free_result($D_Prem_Count);
?>