Connecting to remote SQL server with PHP

[Mutley]

For my local SQL databases I use:

$connection = mysql_connect("localhost", "username", "password") or die("&error1=".mysql_error());
mysql_select_db("database", $connection);

How do I connect to say myothersite.com? I tried replacing 'localhost' with the domain but this doesn't work, still trys to connect to the local server.

 

Thanks in advance.

 

[iarp]

Alot of hosts only allow sql connections from within their own network for security reasons. Other then that, you'd have to contact tech support for the info because if your using a shared server it's network address won't be myothersite.com