Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Nov 2005
    Posts
    148
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Whether my plan is effective?

    Hi, currently my working company have few web system that use for particular department, the system may use in inter department situation.

    Currently, all the login was individual. This also the purpose that i want link all web system that user use only one acct for all web system.

    each system was use own database and each database maintained their user.
    All web system are using PHP and MySQL database.

    my plan is, I create a database that maintenance the user login info for all the web system, each time user login must connect to this database and match their user name and password. If match then connect to the system database else disconnect all database.

    any issued will caused?

    How can i join two table from different database????
    *PHP & MYSQL

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You should not have a problem with what you want to do.

    As for joining two tables from separate databases, you can do that if the user has permissions to select from both databases. then you just name the database as well as the table and column. As an example:

    Code:
    select
    database1.table1.column1,
    database3.table2.column4
    from
    database1.table1
    inner join
    database3.table2
    on
    columnA = columnB


  •  

    Posting Permissions

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