Re: General Mysql Connect
| From: | Waynn Lue | Date: | Thu, 30 Oct 2008 01:32:40 +0000 |
| Subject: | Re: General Mysql Connect | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-282610@lists.php.net to get a copy of this message | ||
>
> Waynn Lue wrote:
>
>> Yeah, it's the same user, same everything (for now). But I wonder why
>> we're seeing these "lost connection" errors and I'm trying to fix
>> it--this was one of the things I was investigating.
>>
>
> Random guess :)
>
> You're overwriting a result or connection variable?
>
> $query = "select * from db1.table1";
> $result = mysql_query($query, $conn1);
>
> while ($row = mysql_fetch_assoc($result)) {
> ...
> $result = mysql_query("select * from db2.table2", $conn2);
> }
>
It's possible, but seems unlikely because the problem only comes up
periodically, not deterministically.