"; if((isset($_REQUEST["selectyear"]) == 1)||(isset($_SESSION["ListYearStandings"]) == 1)){ if(isset($_REQUEST["selectyear"]) == 1){ $currentseason = intval($_REQUEST["selectyear"]); } else { $currentseason = intval($_SESSION["ListYearStandings"]); } $_SESSION["ListYearStandings"] = $currentseason; }//current year has been retrieved $sqlcn = pconnectDBr(); ?> Standings by Group - PCAHA Online Game Sheet Management System

Standings by Listing

Season*

| |   

Note: Click on Group Name to display the Standings for that Group

"; $compcount = 0; if($sqlcn){ $asqlresult = mysqli_query($sqlcn, $asql); if(($asqlresult == true)&&(mysqli_num_rows($asqlresult) != 0)){ $x = 0; while($asqlrow = mysqli_fetch_array($asqlresult)){ ?>
"; $catsqlresult = mysqli_query($sqlcn, $catsql); if(($catsqlresult == true)&&(mysqli_num_rows($catsqlresult) != 0)){ //print "I have ".mysqli_num_rows($catsqlresult)."results
"; while($catsqlrow = mysqli_fetch_array($catsqlresult)){ ?>
"; $divsqlresult = mysqli_query($sqlcn, $divsql); if(($divsqlresult == true)&&(mysqli_num_rows($divsqlresult) != 0)){ //print "I have ".mysqli_num_rows($divsqlresult)."results
"; $divcol = 0; $divcount = 0; while($divsqlrow = mysqli_fetch_array($divsqlresult)){ $divcount += 1; if($divcol == 0){ $colindent = "padding-left: 60px"; //BEGIN TR TAG FOR ROW ?>
No Listing Available from Scheduled Games for This Season.




"; $bsqlresult = mysqli_query($sqlcn, $bsql); if(($bsqlresult == true)&&(mysqli_num_rows($bsqlresult) != 0)){ $tiercount = 0; //print "I have ".mysqli_num_rows($bsqlresult)."results
"; //print "
    "; while($bsqlrow = mysqli_fetch_array($bsqlresult)){ if(is_null($bsqlrow[tierid]) == false){ $tiercount += 1; ?>
    "; if($tiercount == 0){ print "
    No Valid Listing Available
    "; }// mysqli_free_result($bsqlresult); } else {//no result print "
    No Listing Available
    "; }// no result }// no connection ?>
No Division Listing Available
No Category Listing Available
[Back to Top]