mysql_close and html frames

[marsender]

Hi,

I would like to use frames, with mySql connexion.
The problem is that mysql_connect connects in one frame, the in another, and then mysql_close close the connexion (from one frame) so the update from the other frame fails.

In other terms: because it isn's sequential, the connexion is closed by one frame while the other hasn't finished to use the database.

How this problem should normally be solved ???

Thanks

[Shrike]

I don't follow you here. PHP and the MySQL extension have no concept of HTML frames. PHP scripts running in each frame also have no concept of each other. Calling mysql_close() in one script won't affect the running of queries in another script (if that happened then any concurrent processes would suddenly lose their database connection when one finished).

[marsender]

Thank you Shrike,

What you say is what I thaught.

Is the problem due to the fact that I'm running php in cgi mode, under Windows ?

Thanks

[thorpe]

no... the problem is that php is a server-side technoligy and has no clue what a browser is, and nor does it need to know.

[weekender]

the flipside of what shrike said is that you have to connect to the database in each script file - php doesn't share the connection over multiple pages, the link will automatically close at the end of the script regardless of whether you call mysql_close or not

try using [man]mysql_pconnect[/man], and read up on persistent connections