I am working on phpmyadmin.
i want to create a system in which users will select 10 players from pool of players and gain points from those 10 players, just like
fantasy football.
So my first solution was
tables:
users(name,details,team[10],points gained) and players(name,details,points gained by individual player);
but i am not sure how to get that team array in users table.
so i searched for solutions, then somesone suggested about creating one more table team and some thing about foreign keys.
But still i am confused how to do this?
and 1 more question should i use phpmyadmin or mysql workbench to do this . right now i have both installed on system but i have never used mysql workbench.
pls help. Thanks