closing connection

[beco73]

Hi,

Like in many database MSDE, SQLSERVER etc, once you are done with database you close the connection

Conn.close
Set Conn = Nothing


Do we do any such thing in MYSQL?

Thanks

 

[azzazzello]

You should, yes. Depending on the tool you are using, it is more or less important. Perl, for example, will close the MySQL connection for you even if you don't at the end of the script. But maybe another tool won't, and you will have a dangling connection. So yea, close it.

 

[beco73]

I am using PHP, how do you do that, do you know the code?

Thanks

 

[azzazzello]

it is mysql_close()

check out this site for php syntax and stuff. It is very good

http://us2.php.net/manual/en/function.mysql-close.php

 

[azzazzello]

A further comment on this - according the abovementioned link from my previous post, PHP will clean up non-persistent links itself, so you need not do an explicit mysql_close().

 

[beco73]

thanks a lot