Re: losing mysql connection during cron job

[Paul Novitski <paul@xxxxxxxxxxxxxxxxxxx>]

At 6/18/2008 04:49 PM, Shiplu wrote:
> why don't you edit your code?
>
>        foreach (recipients as batch)
>        {
>                mail() using batch of recipients;
>                mysql_query() update table;
>                if(mysql_errno()==ERROR_CODE_YOU_GET){
>                          mysql_connect();
>                          mysql_select_db();
>                }
>                sleep(60);
>        }


Thanks for the suggestion.  I am currently successfully working 
around this error by another method, although your suggestion is 
probably better.

The reason I posted this problem, though, is that I want to 
understand *why* I'm getting the "Lost connection to MySQL server 
during query" error.

If anyone has had a similar experience using cron jobs or sleep() I'd 
love to hear from you.

Thanks,
Paul 


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