For sure here is some sample data home_teams_id,away_teams_id,home_goals,away_goals,home_users_id,away_users_id 100,200,2,1,5,6 200,100,1,1,6,5
Here is two rows of data for the same fixture both home and away Let me know if you need any more info. Cheers Neil On Mon, Sep 6, 2010 at 1:08 PM, Ananda Kumar <anan...@gmail.com> wrote: > 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 >>>> >>> >>> >> >
