database project

karljames · Joined: 08 Jul 2006 Posts: 8 Location: tampa

Hello guys,

I am in need for some one on one help with a personal project.
Their is no profit or gain for me, just knowledge and usefullness for me and my close freinds for my fantasy football league.
What, I want to do is create a database, so I can store data and display on webpage. I also need team management. Trades, add/drops of players, and player profiles as well that will show stats and I can always add to it. I am using phpmyadmin and php for this.

My current website is listed here: http://www.theufl.com/index.php
My current wishlist is here: http://www.theufl.com/ufl_project.htm

Where I want to start is creating the relation databases.
I want to create a site similar to this:
http://www.webleaguemanager.com/demo/reports/FantasyStandingsRpt.html

I the only difference is, I would put each years worth of status for archive purposes. I want to do all of the database work and such.
Just need help on setting up the writing tables.

Would anyone be willing to be my mentor through the project?
I think we should start with the players table. but, I have some questions and would like to speak one on one through IM if possible. This is for a NFL fantasy football league.

Karl
_________________
Karl James
karljames@tampabay.rr.com
theufl.com

lostboy · Joined: 02 May 2004 Posts: 5128 Location: toronto, canada

http://www.developer.com/lang/php/article.php/3636686
_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google

karljames · Joined: 08 Jul 2006 Posts: 8 Location: tampa

lostboy,

I didn't mean to annoy you. I have just been trying to do this for a long time. I did look at your post and the links you provided. However, implementing that is a bit over zealous on my part. To much, out of my league. What, I really need; is to have some one baby step me on creating tables and what cols. I understand the langague and how to create tables.

Could you help me with that?

Karl
_________________
Karl James
karljames@tampabay.rr.com
theufl.com

lostboy · Joined: 02 May 2004 Posts: 5128 Location: toronto, canada

I would start with 3 tables

teams
-------
team_id
team_name

players
--------
player_id
player_name
player_position
[other fields]

user_players
---------------
user_id
team_id
player_id

That should get you started
_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google

karljames · Joined: 08 Jul 2006 Posts: 8 Location: tampa

lostboy,

Thank you so much for replying.
I am greatfull, for sure. What if you I want the players table to be like the players database you see on espn.com and nfl.com. When you click the players tables, like so http://sports.espn.go.com/nfl/players/profile?playerId=1428

I will implement the tables you suggested however.
Do you understand what I want to do, all the way???
Not trying to insult you or anything. Just making sure, we are on the same wave length.

Thanks, please keep the info coming.
I really want to learn and advance.

Thanks again, Karl
_________________
Karl James
karljames@tampabay.rr.com
theufl.com

lostboy · Joined: 02 May 2004 Posts: 5128 Location: toronto, canada

there are other fields you could add to the player table (describing each players personal stats) and other tables (describing game play) you can add to help you get to that level...i recommend starting small and learning about how it all ties together, then buil out from there
_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google