UBB.Developers Forums Community Development Programming MySQL and Server Configuration Mysql close

I was trying out PhpAdsNew on my home computer test site. Everything is fine except that the ad program connects to its own database and does not switch back.

This is the code phpadsnew gives


if (@include(getenv('DOCUMENT_ROOT').'/phpAdsNew/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('', 2, '_blank', '', '1', $phpAds_context);
echo $phpAds_raw['html'];
}


I have tried this

mysql_close($phpAds_raw);

Any ideas how to terminate the connection so Threads can connect to its own database.

If the databases are on the same server, you don't need (or want) to close the connection to switch to a different database. That's done by:

mysql_select_db('database_name') or die("Could not select database 'database_name'\n");

If you do want to close the connection, you would call mysql_close() with no parameters, in which case it closes the last opened connection, or pass it the link identifier returned by mysql_connect().

mysql_close

Thanx I tried the mysql_close ()

mysql_select_db('database_name') or die("Could not select database 'database_name'\n");

The above works fine thanx.