Integrating tables.

Discussion in 'MySQL' started by maihannijat, Nov 15, 2010.

  1. #1
    Hi,

    I have 3 scripts installed under one domain.

    www.chaptersworld.com 1 script
    www.chaptersworld.com/forum/ 2nd script
    www.chaptersworld.com/calendar/ 3rd script


    I have installed all scripts under one folder and database. this database has different tables for each script.
    How to integrate 3 tables which contains members information? that all 3 tables have same values.

    If a row added to 1 table it automatically transfer data to another 2 tables in order to have same rows and values in all table.

    The purpose of this is that users use 1 login information in all three scripts.

    I hope I have elaborate enough my question.

    Thanks in Advance.
     
    maihannijat, Nov 15, 2010 IP
  2. imocoder

    imocoder Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #2
    I suppose you use different scripts.
    There are 2 solutions: use one user table for all scripts, or use 3 (as it is now) and always update each of them on every user table update.
    I should go with the first one.
     
    imocoder, Nov 15, 2010 IP
  3. maihannijat

    maihannijat Member

    Messages:
    48
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #3
    OK thanks for help.

    I will go with first too.
     
    maihannijat, Nov 15, 2010 IP