Closing connection to SQL database

[Ronald Dear]

I've noticed that after a while working with tables in a database I sometimes get an error complaining of too many connections and then I can no longer even log into phpMyAdmin. After some digging I found out that you need to close a connection after you are done with it or else it remains open. I have been using the line:

include("sql.php");

in my php documents that use a db. In that document I have the lines:

$connection = mysql_connect(....)
$database = mysql_select_db(....., $connection)

My question is, do I need to have those lines in the document that uses the DB or can I just call

mysql_close($connection);

in the document that has the include("sql.php"); or do i actually have to have the connection and database lines in the file as well?

Thanks in advance for any help!

[Masna]

Simply...

Code:

mysql_close();

...should work.

Anthony

[Loren Hills]

I agree with Anthony. Also you may want to include it when ever you are done with a connection as is. This should prevent you from leaving connections open on accident. You could also include it in your footer file if you have one.