List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 6 2010 12:10pm
Subject:Re: Query help
View as plain text  
For sure here is some sample data

home_teams_id,away_teams_id,home_goals,away_goals,home_users_id,away_users_id
100,200,2,1,5,6
200,100,1,1,6,5

Here is two rows of data for the same fixture both home and away

Let me know if you need any more info.

Cheers
Neil



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

> 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