I have a question about how to make the databases in mysql, i dont mean the actual code, just how it would be done in theory. I'm still quite new to programming in php and sql as you will notice.
I have a project now where people can register themselves with their info, and the name of their team.
This is going to be a very very simple football (pure text) game where each member has their own team with a couple of players in it.
I'm wondering how i should make the database with the players in it.
The info on each player would be something like:
Name, Age, Skill in passing, Skill in shooting, Running speed, Skill in defending.
Should i make a table called something like "players" and then for each player i add it's values? For example (John Doe, 23, 2, 4, 10, 2)
Is that the way to do it? Sorry if the question seems a bit "fuzzy" but i hope you still understand what i mean.