Code Help Please

[Barand]

I have changed my tables and query, which is now

$sql = "SELECT username
          , week
          , SUM(points)
        FROM 
            (
            SELECT a.username
              , a.week
              , CASE
                    WHEN pick=result THEN value
                    ELSE 0
                END as points
            FROM allpoints a
            INNER JOIN phpfb_picks p USING (username,gameid)
            INNER JOIN phpfb_schedule s USING (week,gameid)
            ) wktots
        GROUP BY username, week";

The results are the same