dat krijg ik heleaas niet voor elkaar
SELECT
dt.af_Player_ID,
ss.Season_Name,
SUM(IF(dt.af_DetailType_ID='1',1,0)) AS BASIS,
SUM(IF(dt.af_DetailType_ID='2',1,0)) AS WISSEL_UIT,
SUM(IF(dt.af_DetailType_ID='3',1,0)) AS WISSEL_IN,
SUM(IF(dt.af_DetailType_ID='4',1,0)) AS GEEL,
SUM(IF(dt.af_DetailType_ID='5',1,0)) AS 2GEEL,
SUM(IF(dt.af_DetailType_ID='6',1,0)) AS PENALTY,
SUM(IF(dt.af_DetailType_ID='7',1,0)) AS ROOD,
SUM(IF(dt.af_DetailType_ID='8',1,0)) AS GOAL,
SUM(IF(dt.af_DetailType_ID='9',1,0)) AS EIGENGOAL
FROM af_details as dt, af_games as gm, seasons AS ss
Where af_Player_ID=$player-ID
and
dt.af_Game_ID =gm.Game_ID
and gm.Season_ID= ss.Season_ID
Group by ss.Season_Name
Order by ss.Season_Name;
En daarna is het voor mij nog de vraag; is die
Order by ss.Season_Name;
dubbel op? omdat ik er al
Group by ss.Season_Name
In heb staan.
en mijn laatste vraag hoe krijg ik e.e.a. netjes in $var in PHP.
