Regarding MySQL and sessions..

[cabadam]

ok lets say I open a connection to a sql server and store that in $db.

Can I register $db as a session variable and then use it throughout that session, or will I need to reopen the connection in each script?

[Anon]

pconnect does that for you, you don't register it.

[cabadam]

so at what point does the connection close then?

[[deleted]]

You must re-open the database connection for every script.

Whenever your script stops, all the identifiers it created (for databases,files, sockets, whatever) become invalid. So you cannot write them to a file or database and use them in another script after the script that created them dies.