|
|
Posted by Shelly on 05/23/05 05:43
"Dave" <dave@REMOVEbundook.com> wrote in message
news:7hq7m2-p5t.ln1@fawlty.homelinux.net...
> While your test machine may have only one (default) database, your
> remote machine will probably require you to specify which db you
> want to use... you can do this right after you connect with a call
> such as
> $status = mysql_select_db($database_ssLogin, $ssLogin);
>
> As an aside, are you sure your webhost allows persistent connections?
> I wouldn't have thought so, but a few might I suppose.
I had one already there:
mysql_select_db($database_ssLogin, $ssLogin);
$encryptedPassword = md5($_POST["password"]);
$LoginRS__query=sprintf("SELECT username, password, level, status
FROM ssusername WHERE username='%s' AND password='%s'",
get_magic_quotes_gpc() ? $loginUsername :
addslashes($loginUsername),
$encryptedPassword);
$LoginRS = mysql_query($LoginRS__query, $ssLogin) or die(mysql_error());
where it fails.
Here is a possiblity. Tell me what you think. On my local machine I am
running PHP5 but I think the server is running PHP4.x
Shelly
>
> --
> Dave <dave@REMOVEbundook.com>
> (Remove REMOVE for email address)
Navigation:
[Reply to this message]
|