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