When to close the connection ?

[habbardone]

When should I be issuing the close db command ?
Do you leave it open after doing a search and do a fresh open for each new query ? Does it close by itself when the .php is not in the browser - (eg when I link to another .php fle in the same window) ?

some advice appreciated! Thanks.

[Roger_Ramjet]

The connection closes when the thread that opened it finishes, ie when your script finishes (generally). If you are not going to run another query in the script then close it, if you are running additional queries then don't: the overhead of openning a connection several times from the same script outweighs the overhead of keeping one open.