Have you got one MySQL copy running or one for each database? If it is on the same sever just use database.tablename.field
Hope this helps... Simon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 11:02 To: [EMAIL PROTECTED] Subject: connect to two databases? Hi, I want to select from two databases at one time, like use forum select .... from users a, auth.users b where a.name = b.name The databases are running on the same mysql server. Do I have to make identical users / passwords for the databases, or can one script connect to two databases using different credentials? There will actually be a few scripts using different databases that all need to access that auth database Regards W. Hamann --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
