[PHP] Forcing close of thread

[jtjohnston]

I have read the FAQ
http://www.php.net/manual/en/function.mysql-close.php
This might even be a mysql question, but I could really use some advice
from people using php scripts to access mysql.

I have been getting a lot of this on my windows/mysql server:

020130 16:11:08  C:\PROGRA~1\EASYPHP\MySql\bin\mysqld.exe: Forcing close
of thread 3  user: 'root'

I get like 20 of them over a period of 20 minutes, according to the
logs.
This hangs my mysql-apache server and causes me to go in and restart it
a lot.

My question is: is this because I have not added mysql_close to any of
my scripts?
Under normal circonstances, I have never ahd to add it before when
running my scripts on a unix server elsewhere.

John



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Forcing close of thread

[jtjohnston]

I'm having growing pains with my mysql server (Windows).

I get a lot of Forcing close of thread ...
Do I need to add mysql_close() to the end of everything? I never had to
before on a Unix mysql server. Is mysql_close($myconnection); correct?
Is it necessary?

$myconnection = mysql_pconnect($server,$user,$pass);
 mysql_select_db($db,$myconnection);

 $news = mysql_query(SHOW TABLE STATUS FROM .$db. LIKE '$table');
while ($news_story = mysql_fetch_array($news))
{
 $table_comment = $news_story['Comment'];
}

mysql_close($myconnection);

?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]