Site deployment

[edwardp]

We are coming close to the point where we are about to deploy an eCom site onto our webserver. But i have a question:

Our website is maintained by a third party company, they have the website files on their server with our dns(www.auto-trail.co.uk). The database (SQL Serever) we use for the site is situated on site.

While developing, i was connecting to the database using:

	$link = mssql_connect("SQLSERVER", $username, $password);
	mssql_select_db("ATVR", $link);

Obviously SQLSERVER is the name of our server locally. Will we have to move te webserver to our server and update the dns info? This is where my understanding of networks falls down.

I hope you can understand what i am asking

regards and thanks in advance

[saraadmin]

Do you mean that the PHP site (webserver) and database server are hosted at two different locations?

If so, then you'll need to use the fully qualified name of the database server machine to connect to it from PHP.

mysql_connect("SQLSERVER.ourdomain,com", ...);

(You may also need to make sure that the database server is visible from outside, check SQL Server's documentation).