Re: Problem with creating parallel connections with mysql_connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I go following debug:

got error <> when doing first connection
resource id was Resource id #3
got error <> when selecting first database
got error <> when doing second connection
resource id was Resource id #4
got error <> when selecting second database

the code was:

$bid=mysql_connect($db_server,$db_user,$db_pass, $allow_multiple);
//error_reporting ( $level);
print "got error <" . mysql_error() . "> when doing first connection\n";
print "resource id was $bid\n";
mysql_select_db($db_db,$bid);
print "got error <" . mysql_error() . "> when selecting first database \n";
//$level= error_reporting ( 0);
$accid=mysql_connect($db_account_server,$db_account_user, $db_account_pass, $allow_multiple); print "got error <" . mysql_error() . "> when doing second connection \n";
print "resource id was $accid\n";
//error_reporting ( $level);
mysql_select_db($db_account_db, $accid);
print "got error <" . mysql_error() . "> when selecting second database\n";

So resource ids seem to be proper, and there is no errors either.

Signup.php already tests $err:

                        $err = mysql_error($accid);
                        if($err=="")
                        {
echo ("<BR><BR><p>".lfunc ("signup_successful")."<BR><BR></p>");
                        }
                        else
                        {
                                echo $err;
                        }

It branches to $err=="", when at same time reporting
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /var/www/bebbicell.ch/signup.php on line 213

This looks really strange.

Aarno

On 18 Jan 2006, at 11:14, David Robley wrote:

On Wed, 18 Jan 2006 19:51, Aarno Syvänen wrote:
Hi List,

decided to try non-permanent connections for  now. So now I have:

<?

/* db.php */
$db_server="127.0.0.1";
$db_user = "asterisk";
$db_pass = "bozzo984";
$db_db = "bebbicell";

$db_account_server="127.0.0.1";
$db_account_user = "asterisk";
$db_account_pass = "bozzo984";
$db_account_db = "asterisk";

$allow_multiple = "true";

//$level= error_reporting ( 0);
$bid=mysql_connect($db_server,$db_user,$db_pass, $allow_multiple);

echo mysql_error();

//error_reporting ( $level);
mysql_select_db($db_db,$bid);

echo mysql_error();


//$level= error_reporting ( 0);
$accid=mysql_connect($db_account_server,$db_account_user,

echo mysql_error();

$db_account_pass, $allow_multiple);
//error_reporting ( $level);
mysql_select_db($db_account_db, $accid);

echo mysql_error();

?>

Still I have same error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /var/www/bebbicell.ch/signup.php on line 212

Warning: mysql_error(): supplied argument is not a valid MySQL-Link
resource in /var/www/bebbicell.ch/signup.php on line 213

Offending statements are:

$res = mysql_query($sql,$accid);

echo mysql_error();

  $err = mysql_error($accid);

Note that I use php-5.1.2RC1 compiled for Darwin Kernel Version 8.3.0
and Macintosh powerpc

Aarno

Try the above to find exactly where your problem is

Cheers
--
David Robley

If I had anything witty to say, I wouldn't put it here.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux