[SOLVED] How to mix group colums with no groups colum?

[JJohnsenDK]

Hey

how do i mix group colums with no group colums?

I have this:

[code]
$sql_actions = "SELECT SUM(a.goal) AS goals, COUNT(a.game_ID) as games, SUM(a.yellow_card) AS yellow, SUM(a.red_card) AS red, SUM(a.mins) AS mins, a.season_ID
FROM actions AS a
WHERE players_ID = ".$_GET['id']."";
[/code]

And get this error:

[i]Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause[/i]

I tried GROUP BY 1 but gets this error:

[i]Can't group on 'goals'[/i]

Anyone who can figure this out?

[taith]

you had "AS a " in the wrong spot...

[code]$sql_actions = "SELECT SUM(a.goal) AS goals, COUNT(a.game_ID) as games, SUM(a.yellow_card) AS yellow, SUM(a.red_card) AS red, SUM(a.mins) AS mins, a.season_ID AS a FROM actions WHERE `players_ID`='$_GET[id]';[/code]