Query help

--00163623ad4e4bc802048f956452
Content-Type: text/plain; charset=ISO-8859-1

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

--00163623ad4e4bc802048f956452--

Re: Query help

--001636833a42cd5d75048f9600f5
Content-Type: text/plain; charset=ISO-8859-1

Tompkins,
Which field stores the result of matches.

regards
anandkl

On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil
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
>

--001636833a42cd5d75048f9600f5--

Re: Query help

--00c09f99defa1a20c2048f9618a0
Content-Type: text/plain; charset=ISO-8859-1

These two fields

home_goals and away_goals

Cheers
Neil


On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote:

> Tompkins,
> Which field stores the result of matches.
>
> regards
> anandkl
>
> On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil <
> neil.tompkins@googlemail.com> 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
>>
>
>

--00c09f99defa1a20c2048f9618a0--

Re: Query help

--0016e64805a8f64641048f96217c
Content-Type: text/plain; charset=ISO-8859-1

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
wrote:

> These two fields
>
> home_goals and away_goals
>
> Cheers
> Neil
>
>
> On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote:
>
>> Tompkins,
>> Which field stores the result of matches.
>>
>> regards
>> anandkl
>>
>> On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil <
>> neil.tompkins@googlemail.com> 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
>>>
>>
>>
>

--0016e64805a8f64641048f96217c--

Re: Query help

--0015175cdd2671dd27048f962a26
Content-Type: text/plain; charset=ISO-8859-1

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 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@googlemail.com> wrote:
>
>> These two fields
>>
>> home_goals and away_goals
>>
>> Cheers
>> Neil
>>
>>
>> On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote:
>>
>>> Tompkins,
>>> Which field stores the result of matches.
>>>
>>> regards
>>> anandkl
>>>
>>> On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil <
>>> neil.tompkins@googlemail.com> 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
>>>>
>>>
>>>
>>
>

--0015175cdd2671dd27048f962a26--