mysql database access

[akravets]

Hi,

I have collection of web pages and in each of them I use data from database. If I connect to a database in my first page, do I need to execute mysql_connect on all other pages, or is it enough to establish connection on first page and just querying the database on all following pages?

thanks,
Alex

[PHPdev]

I think what you are asking for is a persistant connection. I think ther is a mysql_pconnect() or something like that. But then too it is a good practice to:

Open connection
Preform Query
Close Connection

This can improve performance of the pages

If you are just using the mysql_connect then yes you will have to do this for every page...

Thanks

PHPdev