Unable to locate the dirty-dawg database at this time.');
}
$sql2 = "select ID from PFCCGroups where GroupName = '$GName'";
$result2 = mysql_query($sql2);
$row2 = mysql_fetch_array($result2);
$ID = $row2['ID'];
$PFCCID = "PFCCGroup$ID";
$sql = "select GroupName, GroupDesc from PFCCGroups where ID = $ID";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$Name = $row['GroupName'];
$Describe = $row['GroupDesc'];
$sql = "Select Members.MemberName as PlayerName, Members.MemberCityPlay as City, Members.MemberFileName as FileName,
Members.MemberStatePlay as State,
$TotalsTable.Points as Points,$TotalsTable.Place as Place,
$TotalsTable.Wins as Wins, $TotalsTable.Losses as Losses, Members.ID as ID from Members,$TotalsTable,
$PFCCID where Members.MemberHandle = $PFCCID.MemberHandle and $PFCCID.MemberHandle = $TotalsTable.MemberHandle
order by Points DESC, Wins DESC";
$result = mysql_query($sql);
echo ("
dirty-dawg Pro Football Confidence Contest Intra-Group Standings
PFCC 20$Year
Intra-Group Standings
After Week: $PFCCWeek
Group Name: $Name
Description:
$Describe
| Group Place |
Overall Place |
Player |
Points |
Wins |
Losses |
PB |
");
$i = 0;
while ($row = mysql_fetch_array($result)) {
++$i;
$ID = $row['ID'];
$Place = $row['Place'];
$FileName = $row['FileName'];
$PlayerName = $row['PlayerName'];
$Points = $row['Points'];
$Wins = $row['Wins'];
$Losses = $row['Losses'];
$City = $row['City'];
$State = $row['State'];
$location = "$City, $State";
if ($i == 1) {
$TopScore = $Points;
}
$PB = $TopScore - $Points;
echo ("
| $i |
$Place |
$PlayerName
($location) |
$Points |
$Wins |
$Losses |
$PB |
");
}
echo ("
");
include("../php_includes/footer.inc");
?>