Though I can setup an almost same database as another server, I'd like to directly connect to the other server. To do like this, one edit will affect 2 sites.

Can we use like this:

Quote:
$db_host = "202.101.93.94"; or like: $db_host = "http://anotherdomain.com";
$db_user = "dbuser";
$db_pwd = "dbpwd";

$qry = mysql_connect ($db_host, $db_user, $db_pwd);

__________________

Is your web server on the same network as the DB server? Do you have a web hosting plan with one company and a DB plan with another? What type of plan? There are several variables that would determine an answer.

Hi tiamaz,

your code...

$db_host = "202.101.93.94"; or like: $db_host = "http://anotherdomain.com";
$db_user = "dbuser";
$db_pwd = "dbpwd";

$qry = mysql_connect ($db_host, $db_user, $db_pwd);

Should work fine depending on how your database server is setup. You need to make sure the server your connect from has access to the remote database server - by default the remote database server probably restricts access from IP's off their range....

What database is it? Maybe we can help more. also, if there actually a problem or have you not tried your code? If there is please post the errror.

Warm regards,