I want to know that if we are connecting mysql using mysql_connect , the connection to the db will last untill we go to the next page? or after every transaction the mysql detach the connections....
Can some one please explain about mysql connection scope in detaill....????

http://www.php.net/manual/en/function.mysql-connect.php

Note: The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling mysql_close().

If you are using only 1 database for your website just add a connection to the header of your page, that way you are only connecting once, and if you need to change connection info for any reason, you only need to edit one spot.

Originally Posted by randon

If you are using only 1 database for your website just add a connection to the header of your page, that way you are only connecting once, and if you need to change connection info for any reason, you only need to edit one spot.

Even if you include your database code in your header you will still have to connect everytime the header is called (ie for each new page).

You are, however, right about localizing your database code. I usually have a db.php file containing my database code, and I just include if I need to access the database. This will not prevent your database connection from closing when your script is finished executing (as Tripy said).

The short explanation is this...

when you create a connection, it is not closed until one of two things happens.

1) you call mysql_close()

2) the page execution ends.

If you don't call mysql_close(), the connection will stay open until you're page finishes execution.