Is it possible?

Yes it is possible (IMO the first thing a programer should learn is that everything is possible if you can afford it).

if you want some help i would need to know how exactly you want this to work. Is the score for the team going to be updated after the game is over, once a week or as soon as the player score, the way you are going the structure your tables will also change how you are going to code this

Well the player score will be updated once a week probably. I am guessing that that would make it easier.

I don't know since i don't know how you are going to build your tables.

Let me explain how i would do it.
make a table only for the score. each time somebody scores add a row with the game_id Player_id team_id. then you can use this table to display the score of that game the total for a player or for a team.

I think I have explained this badly so let me try again. A player plays a football match and gets so many points for his performance, let's say 10.

I then want to enter the 10 points into a database and that automatically adjusts the scores for people who have that player in their team. The table then changes to reflect the points change of the team.

Does that make any sense to you guys lol! I'm not too good at explaining!

So if I was to create a table for every player in the game (could be a lot) and then enter the points for every player into that? Or...is it possible to do something like create a table for the team that they play for. For instance, David Beckham would go under Manchester United and I change the scores under that yet it is still reflected in the fantasy team?

AARGH! I'm confusing myself now lol. Also how easy is it to set up a system where people could be able to register on the site and then be able to access things about their team etc?

Many thanks for this guys, I appreciate all your help and I know that I can easily confuse people. So once again many thanks!

[EDIT]
Ok. I have had a play around with MySql and that has brought something else to my mind. The user registers with us and they select their team etc. That would create a new field in the database for their team right? Oh god...it is starting to get confusing now. So I think I should tackle one issue at a time.

The first issue should be how I get people to be able to login to the site and change their team etc.

Once again, I offer my thanks and condolences to the people how help me! Many, many, many thanks!
[/EDIT]:)

Ok First you need to understand the concept of a db let say i create a table TEAMS and it look like this

|team_id|team_name|team_color|etc...
|-------|---------|----------|----
|1 |toto |red |

now i'll create a table for players the player will always have a team related to them so i will put a field team_id in it when i add a player i put the id of the team he has joined in it. like this

|player_id|team_id|player_name|etc...
|---------|-------|-----------|----
|23 |1 |bozo |

like this by looking up all player whose team_id is 1 i will get all players from team toto

Yeah ok I understand that. I tested it in MySql and it worked. I can handle databases like Access but MySql seems to be different somehow. So what next boss?! lol

I am currently reading the mysql.com manual, and doing the tutorial. I think that will help! Although I probably will need help later on!

I guess that now you have to start your project by yourself and ask for hints when you get stuck. Yes mysql is different from access it is a lot faster and can handle a lot more connections.

Well I am yet to actually design the site so what should I do first? Design the database and tables etc or design the site? I am looking to set up some the site so that people can register on the site. Still not sure how to do that yet! Can you guys help me?

Thanks for guiding me in the right direction though lol!

well there are to methods. Personally i don't do design (the comments i have when do tell me i'm a good programmer but not a designer). Starting by the design you can set all the buttons forms and menus that you need and then only worry about making them work.If you start by coding then you'll know what you need to design after. It's up to you to choose witch one make you more confortable