[snip]
Now here's a bit of an oddball question:
I am building a php/mysql web app that will be linking with an
accounting system in PervasiveSQL. Right now the various pieces of the
web app are built in mySQL.
Is there a way to do JOINS between tables in the two different
databases?
[/snip]
The problem that you will run into is connecting to both databases. Normally
in PHP you use something like the following to connect to a single database;
$dbconnect = mysql_pconnect("127.0.0.1", "user", "password");
mysql_select_db("mydatabase", $dbconnect);
Using the PHP native connections to MySQL. Assuming PervasiveSQL has an ODBC
connection available it can be done.
I have seen it done, here are some examples with 2 MySQL databases;
http://www.phpbuilder.com/forum/read.php3?num=2&id=164799&thread=164798
http://www.phpbuilder.com/forum/read.php3?num=2&id=167141&loc=0&thread=16713
5
I also found these by doing this search at Google;
http://www.google.com/search?hl=en&q=PHP+%22connect+to+two+databases%22
HTH!
Jay Blanchard
Applications Development
nii communications, inc.
210-403-9100 x285
---------------------------------------------------------------------
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
