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