Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Whether my plan is effective?
02-06-2007, 03:43 PM #1
- Join Date
- Nov 2005
- 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
02-06-2007, 05:14 PM #2
- Join Date
- Mar 2006
- St. Catharines, Ontario Canada
- Thanked 147 Times in 138 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:
select database1.table1.column1, database3.table2.column4 from database1.table1 inner join database3.table2 on columnA = columnB