Hello
Im beginning to create a fantasy soccer league using php/mysql. I have a few ideas on how to go about creating the database but i thought I would ask some others i.e. you lot who are probably more experienced with mysql than myself.
Basically there will by two main tables, one for all the real players in the league, and one for the user created squads by users of my site.
Its the 'points' fields ive been struggling with. What I want is for a user to see any players points for any given week. So each player would need a week1points, week2points, week10points etc.
Also in the league transfers will be involved, so my question is what would be the best way to go about storing which squads have which players for each week- would I have to have the table holding each squads team for each week - eg squadname, week1player1 week1player2 week1player11 - week2player1 week17player5 etc etc
also does anyone have any other ideas to help me with this project, or know of some example code for a fantasy league which I could take a look at?
cheers guys.
mike
