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
So my first solution was
users(name,details,team,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