SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard dethfire's Avatar
    Join Date
    Aug 2000
    Posts
    2,477
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help with structure visualization

    I am creating a newsletter website. Upon registration the user will be able to select theoretically a hundred newsletters to receive. My question is how do I store that data in the database? Each newsletter is unique and each user will have a different selection of choices. I won't want to make 100 different table columns for each newsletter will I? Any ideas?
    Free Science Homework Help
    http://www.physicsforums.com

  2. #2
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    three tables
    member(id, etc, etc)
    selected(id,newsID)
    newsletters(newsID, etc, etc)

    in other words a standard many to many relationship resolved into two one to many relationships. This is very basic Databases 101...


Bookmarks

Posting Permissions

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