List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 6 2010 12:08pm
Subject:Re: Query help
View as plain text  
Also, can u please lets u know the value's in this table.
Just one row, an example would do.

regards
anandkl



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

> 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