Standings by Listing
$hashcount = 0;
$hashsql = "SELECT DISTINCT competition.competition AS competition
FROM competition
INNER JOIN gameschedule ON competition.competitionid = gameschedule.competitionid
WHERE gameschedule.seasonid = $currentseason
AND competition.standingsApplicable = 'Y'
ORDER BY competition.competition;";
if($sqlcn){
$hashsqlresult = mysqli_query($sqlcn, $hashsql);
if(($hashsqlresult == true)&&(mysqli_num_rows($hashsqlresult) != 0)){
?>
while($hashsqlrow = mysqli_fetch_array($hashsqlresult)){ ?> | = $hashsqlrow[competition] ?> | $hashcount++; }//end loop ?>
}//end has records }//end connect good hash comp ?>
while($hashsqlrow = mysqli_fetch_array($hashsqlresult)){ ?> | = $hashsqlrow[competition] ?> | $hashcount++; }//end loop ?>
Note: Click on Group Name to display the Standings for that Group
}//end has records }//end connect good hash comp ?>
= $asqlrow[competition] ?> |
||||
= $catsqlrow[category] ?> |
||||
if($sqlcn){
$mycompetitionid = $asqlrow[competitionid];
$mycategoryid = $catsqlrow[categoryid];
$mydivisionid = $divsqlrow[divisionid];
$bsql = "SELECT DISTINCT tiers.tierid
, tiers.tier
FROM tiers
INNER JOIN gameschedule ON tiers.tierid = gameschedule.groupid
WHERE gameschedule.competitionid = $mycompetitionid
AND gameschedule.categoryid = $mycategoryid
AND gameschedule.divisionid = $mydivisionid
AND gameschedule.seasonid = $currentseason
ORDER BY tiers.tier;";
//print "TIER: $bsql "; $bsqlresult = mysqli_query($sqlcn, $bsql); if(($bsqlresult == true)&&(mysqli_num_rows($bsqlresult) != 0)){ $tiercount = 0; //print "I have ".mysqli_num_rows($bsqlresult)."results "; //print "
}// end if is null tier id. }// end loop //print " No Valid Listing Available"; }// mysqli_free_result($bsqlresult); } else {//no result print " No Listing Available"; }// no result }// no connection ?> |
if (($divcol == 4)||(countUniqueDivSked($currentseason, $asqlrow[categoryid], $asqlrow[competitionid]) == $divcount)){
$divcol = 0;
//END TR TAG FOR ROW
?>
||||
No Division Listing Available | ||||
No Category Listing Available | ||||
[Back to Top] |