At 20:23 -0800 3/26/02, Foo Yong Choon wrote: >i tried to catch the exception and recoonect to MySQL >server and it >dose not work, i also tried open and closing the >connection only when i need it and that does not work >too so i had to resort to not this alternative. anyway >thanks fr your solution.. and how to make disable auto >closing indefinately instead of setting the timeout >value?
Catching the exception and reconnecting, or opening and closing the connection only when you need it, are both techniques that should work. Sorry to say this, but it really sounds as though your program has problems that don't have all that much to do with the timeout behavior of the MySQL server... --------------------------------------------------------------------- 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