ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7 select S.*, D.Name, D.IsACupBoolean, D.DivisionID from Divisions D, Seasons S where S.SeasonID = D.SeasonID and D.DivisionID =
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/denis/public_html/BSLApp/Standings.php on line 34
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and L.TeamID = T.TeamID and (L.SubDivision = "" or L.SubDivision is null' at line 19 select T.TeamName, T.TeamID, sum(case when R.TeamID is not null then 1 else 0 end) GP, sum(if(Score > OpponentScore, 3, 0)) + sum(if(Score = OpponentScore, 1, 0)) - max(Deduction) P, sum(if(Score > OpponentScore, 1, 0)) W, sum(if(Score < OpponentScore, 1, 0)) L, sum(if(Score = OpponentScore, 1, 0)) D, sum(COALESCE(Score, 0)) GF, sum(COALESCE(OpponentScore, 0)) GA, sum(COALESCE(Score - OpponentScore, 0)) GD, max(Deduction) Deduction, max(DeductionReason) DeductionReason, (select D.EndYear from Divisions D where D.DivisionID = R.DivisionID) EndYear from Teams T, Leagues L left outer join ResultsTemp R on L.DivisionID = R.DivisionID and L.TeamID = R.TeamID where L.DivisionID = and L.TeamID = T.TeamID and (L.SubDivision = "" or L.SubDivision is null) group by L.TeamID order by P desc, Deduction, GA asc, GD desc, T.TeamName