From: Ananda Kumar Date: September 6 2010 12:08pm Subject: Re: Query help List-Archive: http://lists.mysql.com/mysql/222867 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e64805a8f64641048f96217c --0016e64805a8f64641048f96217c Content-Type: text/plain; charset=ISO-8859-1 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 wrote: > These two fields > > home_goals and away_goals > > Cheers > Neil > > > On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote: > >> 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 >>> >> >> > --0016e64805a8f64641048f96217c--