fenway

Yeah, you can't do that.... SUM() can't take a result set.

Solved how?

which mysql version?

Wait a second... there's an "OR" in the where clause!!!

Sorry, I still have no idea what the problem is.

Ha! Funny... sorry about that: SELECT scorer, sum(goals) as total_goals, Sum(IF(team_id =1 and league="league",goals,0)) AS firstleague, Sum(IF(team_id =1 and league="friendly",goals,0)) AS firstfriendly, Sum(IF(team_id =2 and league="friendly",goals,0)) AS fathoms, Sum(IF(team_id =3 and league="friendly",goals,0)) AS badgers from `tbl_scorers` group by scorer order by total_goals desc;

Start again -- new file, new script -- run a simple query, make sure it works.

I don't understand... does the equivalent select query pull all of the towns?

Huh?

Where the SET NAMES from php?

Give me a few INSERT statements, and I'll get to work...

The "@" suppresses errors....

Bizarre... and if you actually specify a new IDs directly it's fine?

Maybe *all* isn't the best idea -- isolate the query first.

What's "it" in this case... there's a php side to this issue as well.

Since you're supressing errors, we're not going to get very far.

What's the error now?

If I think I get what you're saying, it's that the non-aggregated columns are producing garbage... correct/

You were on the right track... just remove the trailing comma after badgers before FROM.

Huh?

The PHP Help forum is pefect for stuff like this.. do you want me to move this thread?

You could, though, with ALTER TABLE, say for a table that isn't being updated anymore (e.g. ARCHIVE).

So?

Well, you simply sort your results set with the first ID... and then if the next ID isn't different, add a column, otherwise, add a new row, etc.

Why not simply: SELECT scorer, Sum(IF(team_id =1 and league="league",1,0) AS firstleague, Sum(IF(team_id =1 and league="friendly",1,0) AS firstfriendly, Sum(IF(team_id =2 and league="friendly",1,0) AS fathoms, Sum(IF(team_id =3 and league="friendly",1,0) AS badgers, FROM tbl_scorers group by scorer