Connections to mySQL

[digitalgravy]

If I have multiple php scripts in one page, and they all get info from my DB, do I have to connect to the DB for every script?, or can I use one connection in the first script and make my queries in the remaining scripts?

I appreciate any help.

[Redcircle]

you can make a connection and put the connection information into a variable and reference to it when you run the other script.

Code: Select all

<?php
$db = mysql_connect($host,$user,$pass);


//first script
mysql_query($query,$db);

//second script
mysql_query($query, $db);
?>

[philipo]

Or you can use mysql_pconnect() function.

mysql_pconnect() always check if there's a connection already... you know...