Re: Problem with creating parallel connections with mysql_connect
| From: | David Robley | Date: | Wed, 18 Jan 2006 10:14:53 +0000 |
| Subject: | Re: Problem with creating parallel connections with mysql_connect | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41055@lists.php.net to get a copy of this message | ||
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.