Hi,
Here is the way I would fix that problem
(assuming you're a programmer)
write a simple function check_connection(MYSQL **conn) for example.
that will issue a query "SELECT NOW()" to mysql, if that query fails
that means connection to mySQL has gone away and the function has to
reconnects to mySQL, if not then life is good and the function
exits without having to do anything else.
Now after writing that function, call it right before executing
any query in your program.
Regards,
SC
--
Nothing Like the Sun
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
