|
|
Posted by Shelly on 05/23/05 04:45
I have identical names for the database, user and password on the local
machine and on the remote site. I also have identical tables and info in
the tables. It works perfectly on the local machine. On the remote site I
get "No Database Selected". It happens in the mysql_query call.
echo "ssLogin = " . $ssLogin . " ";
$LoginRS = mysql_query($LoginRS__query, $ssLogin) or die(mysql_error());
echo "LoginRS = " . $LoginRS;
This gives:
ssLogin = Resource id #3 No Database Selected
On both machines I have have a require file which is:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ssLogin = "localhost";
$database_ssLogin = "the_database_name";
$username_ssLogin = "the_username";
$password_ssLogin = "the_password";
$ssLogin = mysql_pconnect($hostname_ssLogin, $username_ssLogin,
$password_ssLogin) or die(mysql_error());
?>
I thought it might be the $hostname_ssLogin, that it had to be something
else. However, if it is not localhost, then the mysql_pconnect fails.
Any ideas?
Shelly
Navigation:
[Reply to this message]
|