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.tompk...@googlemail.com>wrote: > 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 >>> >> >> >