From: Ananda Kumar
Date: September 6 2010 11:58am
Subject: Re: Query help
List-Archive: http://lists.mysql.com/mysql/222865
Message-Id: <AANLkTik_LZYAPwxJiL7nRh--kFMg0TujsL-dmuJPCVxD@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001636833a42cd5d75048f9600f5

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

--001636833a42cd5d75048f9600f5--