Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    USA
    Posts
    4,342

    Question How Do I Organize A MYSQL Database, with unlimited 15-12-and 150 fields?

    I have 15 fields for explorer verisons possible, 12 for user's system and around 120 for countries..

    How do I organize them all in one database, btw the database is for visitor tracking...

    Thnx
    Testing 1.. Testing 1..2.. Testing 1..2..3...

  2. #2
    Join Date
    Mar 2004
    Location
    USA
    Posts
    4,342
    ok i thought of it...

    i made a feild for each one...

    but the countires..... I still have to do that??? 120??
    Testing 1.. Testing 1..2.. Testing 1..2..3...

  3. #3
    Join Date
    Jan 2003
    Posts
    1,715
    For something like that, I would probably go with a vertical design

    Siteid | Country | Count
    12 | China | 862
    12 | Canada | 1231
    ...
    Game Servers are the next hot market!
    Slim margins, heavy support, fickle customers, and moronic suppliers!
    Start your own today!

Posting Permissions

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