Team,
I am trying to create a fantasy football website.
My project page is listed hear:
http://www.theufl.com/ufl_project.htm
Tools I am using are:
I am using phpmyadmin and php of course with dreamweaver.

My first dillemma is what tables to create.
I know i need a players table, owners table, transactions table(for trading adding,dropping and trading players), but I do not know what else I need.
I also want to emulate a page a www.espn.com
http://sports.espn.go.com/nfl/player...e?statsId=4256
The players page. However I am confused on how to start my tables.
I want to do the grunt of the work first obviously with the players table,
which will be the primary goal of this project.
The question I have immediately towards this table is do i include the stats and the player bio stats all in the same table, or do i break them up I will have a players page or year page in stats to view the players name by name and team by team. How do you suggest I do this.
Also, if you could elaborate also on what tables and fields I would need for this database would be so appreciated.

you can email me directly at:
karljames@tampabay.rr.com
I am also on aim kjames1973.

thanks,
karl

Look at the page and think about one to many relationships. What information is there one instance of and what information are there many instances of that you can see?

I suggest you do the first draft of the datamodel yourself. Then come back and ask for feedback. We're not here to do your homework.

Certus,
I wasn't asking for you to do my homework for me.
I am simply asking advise.
I am sorry if I am not a senior in database making.
I wish I was so I wouldnt have to ask these kinds of questions
but I am trying to learn, surely you were in my position at one
time when you didnt know what a database was.

I am sorry if I come across needy, but I really do need the help.
I am just frustrated. I am reading all I can read but with out further
explanation its hard sometimes,and I also am sorry I do not know how
to ask the right questions if I am confusing.

I have created the players table already in my db.
However I am not sure if I should keep the players bio and players stats
all in the same place.

thanks, Karl

Do a screen capture of your players table. Post it as an attached image.

We'll take it from there.

Name the books you have read on the subject. Then show us the work you have done and ask specific questions.
Don't worry about 'how', just ask it.

Well,
I think I did ask. How do i set up this players table if i want to copy the table that espn.com has. DId they throw all Bio stats and players into one table in the database or are they seperate.
The link again was.http://sports.espn.go.com/nfl/player...e?statsId=4256

espn probably treats it as a data warehouse for rapid retrieval. But I am not going to go into that.

Again. Look at what data on the page has only one instance. That is your first table. Then look at data groups of which there are many instances. These are your child tables.

Well,
You are probably right on that.
Its a way for them to save money I a sure.
How can I send you a screen shot of what i have so far.
I have not finished this table but at least I can show
you what I have going for you, to show you where I am at for
this particular table.
I am using phpmyadmin to enter in table info.

shift-PrtSc

open MS paint

Cntrl-V

Save as jpeg.

Attach to your next post using manage attachements.

Certus,
I could not find paint on my pc.
However, I pasted this in word.
Let me know if you do not have word.
If you have it can we please try to go
into more detail on how i should start these
tables i need for this project.
Your help would be greatly appreciated.
I basically need a template. Is that so
wrong to ask for?

Thanks for any more info and your help buddy!
Karl

judging by that screenshot you are on Windows XP, so go Start > Programs > Accessibility and vwalah, there it is, Paint

first point -- don't use spaces in a column name

next, split off those columns which pertain to a player's current team (e.g. Position, Number) into a PlayerTeam table

see Introduction to Data Modeling

Gosh - I didn't know you could speak French.

Nice Data Modelling link too

pootle flump ur codings are working excelent.

What are you trying to say pootle flump.
Are you referring to me or r937?

Karl

Looking at that screen shot you should separate team from player. You should also note that you have several aggregate values that should be handled as nonaggregates in separate tables.