code help

[Anon]

Hi,

I am trying to loop my connection so that my users do not get an error message if the connection is busy. This seems to work, however, it will not print a single message(ie "Please Be Patient While We Process Your Request") while the connection is being retried. Instead, I get a million warning messages down the page until my connection is established. I would appreciate any help anyone can give....here is the code....

while (!$link = mysql_connect("host","user","password"))

{$link = @mysql_connect ("host","user","password")
or die("Please Be Patient While We Process Your Request");}

Thanks For Your Help In Advance!

PG

[Anon]

Why dont you use mysql_pconnect instead ? much faster if you have lots of users.

Now to your problem, is this a possible
solution ?

$link = @mysql_pconnect("host","user","password");

if ( !$link )
echo "Please Be Patient While We Process Your Request";

for ( retiries = 0; !$link && $retries < 100; $retries++ )
$link = @mysql_pconnect("host","user","password");

if ( !$link )
{
echo "Unable to establish connection..."
exit;
}

Rgds - Dan