> -Original Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: Wednesday, August 25, 2010 2:06 PM
> To: Travis Ard
> Cc: [MySQL]
> Subject: Re: Calculating table standings
>
> Travis
>
> Do you think it would be better if I stored t
it is too awkward to
query this table twice and union the results, then you might want to add a
summary table.
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 2:06 PM
To: Travis Ard
Cc: [MySQL]
Subject: Re: Calcula
s lost_away
>,away_goals as scored_away
>,home_goals as conceded_away
> from matches) s1
> group by seasons_id, team_id;
>
> -Original Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: Tuesday, August 24, 2010 7:45 AM
> To: [MySQL
y
>,if(away_goals < home_goals, 1, 0) as lost_away
>,away_goals as scored_away
>,home_goals as conceded_away
> from matches) s1
> group by seasons_id, team_id;
>
> -Original Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: T
, August 24, 2010 7:45 AM
To: [MySQL]
Subject: Calculating table standings
Hi,
I wondered if anyone can offer me some help with regards the following issue
I'm having. Basically, I've the following table structure containing rows
of results between two football teams. The fiel
Hi,
I wondered if anyone can offer me some help with regards the following issue
I'm having. Basically, I've the following table structure containing rows
of results between two football teams. The fields are
match_id
seasons_id
week_number
home_team_id
away_team_id
home_goals
away_goals
Based