Which field stores the result of matches.
On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil
> I've the following fields within a table :
> 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 ?