From your description of the problem, it sounds liker you edited the names of the variables in the connection, not just the values.
for example, if I create a connection named test, the code in my connection file will look like this:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_test = "localhost";
$database_test = "test";
$username_test = "root";
$password_test = "rootPW";
$test = mysql_pconnect($hostname_test, $username_test, $password_test) or trigger_error(mysql_error(),E_USER_ERROR);
?>
when you edit this for the remote server, the variable names must stay the same, only the values of the variables get changed:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_test = "remoteServer";
$database_test = "remoteDB";
$username_test = "root";
$password_test = "rootPW";
$test = mysql_pconnect($hostname_test, $username_test, $password_test) or trigger_error(mysql_error(),E_USER_ERROR);
?>
if you change the variable names, for example:
$hostname_test
it will cause the errors you are describing.