List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 6 2010 11:58am
Subject:Re: Query help
View as plain text  
Tompkins,
Which field stores the result of matches.

regards
anandkl

On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil
<neil.tompkins@stripped>wrote:

> Hi,
>
> I've the following fields within a table :
>
> fixtures_results_id
> home_teams_id
> away_teams_id
> home_goals
> away_goals
> home_users_id
> away_users_id
>
> From this I want to extract the following type of information if
> the home_users_id or away_users_id = 1 :
>
> total number of games games
> number of games won
> number of games drawn
> number of games lost
> number of goals scored
> number of goals conceded
> biggest win
> biggest loss
> most goals in a game
>
> I'd appreciate any help with regards the query and whether or not it is
> possible to do ?
>
> Cheers
> Neil
>

Thread
Query helpTompkins Neil6 Sep
  • Re: Query helpAnanda Kumar6 Sep
    • Re: Query helpTompkins Neil6 Sep
      • Re: Query helpAnanda Kumar6 Sep
        • Re: Query helpTompkins Neil6 Sep