These two fields home_goals and away_goals
Cheers Neil On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar <anan...@gmail.com> wrote: > 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 >> > >