Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Question about planning a mysql database

    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.

    Thank you very much in advance.

  2. #2
    Join Date
    Feb 2004
    That sounds about right.

    If you want to go deeper in the future, I suggest learning about database normalization.

  3. #3
    Join Date
    Feb 2004

    More about normalization

    Here's an article about normalization...


    (brief into... there's lots more out there.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts