List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 6 2010 12:05pm
Subject:Re: Query help
View as plain text  
These two fields

home_goals and away_goals

Cheers
Neil


On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar <anandkl@stripped> wrote:

> 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