Linking to table together?

[JJohnsenDK]

Hey

im trying to make a stat site for football(soccer) players. I have a stat archive where players from the season(just examples) 2005 is stored in 2005 and players from 2004 is stored in 2004 and so on. And that works fine. I also want a "best team of the season" in for example 2005. This "best team of the season" contains 11 players for each season and we are talking season way back, to like 1955. So in my database i made a table contaning this for my "best team of the season":

table: wof_best
rows: wof_best_id, wof_best_pos
in wof_best_pos i created the 11 postions on the football field, goalkeeper, defence1, defence2 and so on like this:

gk, d1, d2, d3, d4, m1, m2, m3, m4, a1, a2.

Then i have a table containing all the player stats, where i have a row that should indicate if the player have been selected for the team and what position he have been selected in.

table: wof_pl
row: wof_pl_best

And here is where i go blank cause i cant figure out how to link these to tables together, so if i write for example a1 in wof_pl_best the players is showed as attacker1 in "best team of the season".

Long thread, but i really hope someone can help me.

[themightystephen]

This is more of a MySQL database design problem. If you post this in the MySQL forum you're far more likely to get some replies from people who are more experienced with dealing with problems like yours.