[Resolved] connecting to multiple databases

[happyme]

I look after 13 websites which are hosted on 2 different servers - the main site on one server and a load of regional sites on another. I can't change anything about this.

I've developed a diary on the main site sites using php and a Mysql database and it works very well.

I'd like to create a diary on the regional sites which combines data from the main database on a remote server and a regional database on localhost.

Can I connect to a database on a remote server? How? Do I need to close one connection before I open another?

TIA

Julia

[notionlogic]

Can I connect to a database on a remote server? How? Do I need to close one connection before I open another?

Yes, just specify the correct database login details (including server name).

No you don't need to close one connection before opening another just use seperate variables to hold each conn id !

Hope this helps

[happyme]

hmm didn't work:

$db = mysql_connect($ipaddress, $username, $password)or die("Technical error, ".mysql_error());

As you can see I substituted the IP address for localhost and got:

Warning: Access denied for user: '[e-mail]' (Using password: YES) in path/test.php4 on line 9

(line 9 quoted above)

does this mean my server won't let me connect remotely?

Julia

[siwis]

I'm not sure for certain (as I've never tried this) but you just need 2 connection strings, one for each server where you need to connect to data.

If I'm guessing correctly, the username part of the connection string would be user@IPaddress

Then when doing your queries,, assuming you've set one connection string up as $db1 and the other as $db2 you then simply drop the connection variable at the end of the relevant query:
$local_query = mysql_query("$sql", $db1);
$remote_query = mysql_query("$sql", $db2);

But its all guess work and I've no means of testing.

[notionlogic]

The database on the remote server must grant the correct privileges to that username and host

Check the settings in the MySQL HOST and USER tables on the remote machine for the username you're using and the host you're trying to connect from

[happyme]

ahh therein lies the problem

Following conversation with the guy who runs the main server, it seems 'The permissions to access mySQL remotely are not set as the server is a shared server blah blah blah...'

So I can't connect remotely
I'll find another way round it.

Thanks for the help...

Julia