FN-FORUM: PHP / MySQL Closing connections

date posted 21st August 2003 16:17

Just checking a few things.

In a php script when you connect to a database (mysql_connect) then run a
few queries and the page exits, does it automatically close the connection
to mysql or do you have to close it in the code? I know it may be bad
practice not to close it but I was under the impression it closed itself.

The other problem is that when I run a CHECK_TABLE command on a table in
the database I get e.g. '12 clients is using or hasn't closed the table
properly'. The check table command seems to clear this warning and running
it again says the table is ok, but after a few days it starts to build up
again the longer I leave it the more clients haven't closed the table
properly. Is this a normal occurrence or have I made an oversight somewhere?

Thanks in advance,

Bill