How to connect to external db?

[gojira2005]

This is bound to be embarassingly simple!

I have a mysql database hosted on one of sites. I would like another of my sites to link to it.

However, I cannot make a connection!

The code I am using is as follows:

 $connection=mysql_connect("[URL unfurl="true"]http://localhost.sitename.biz","username","password")[/URL]       or die("Cannot connect to mysql server");

this is the first time I have done this so please be gentle on me! Thanks.

 

[azzazzello]

the HOST parameter takes in either an IP address or DNS name of the target. Http:// is a protocol specifier that is for browsers use; it is not part of the hostname. If your hostname is localhost.sitename.biz, just put that there. Make sure you can resolve it with DNS. If not, but it in the DNS. If you can't, just put the IP instead. Either way, get rid of *

http://*