Problem with MySQL DB Connection Class not closing.

[pblancher]

Someone I used to work with built this and I use it on all of my items now. However it appears that it is not closing the database connection like its suppose to. I have a lot of MySQL processes running on the server that shouldnt be as many. The Class is below as is how its used in the code.

/////////////////////////////////////////////
class DB {
function DB() {
$this->host = "localhost";
$this->db = "database";
$this->user = "username";
$this->pass = "password";
$this->link = mysql_connect($this->host, $this->user, $this->pass);
mysql_select_db($this->db);
}

function close() {
mysql_close($this->link);
}
}
///////////////////////////////////////////////
To use it.
$sql="A query goes here";
$open_db = new DB; // Opens the connection
$result=mysql_query($sql);
$open_db.close; // Closes the connection

////////////////////////////////
In the error log...

[error] PHP Notice: Use of undefined constant close - assumed 'close' in /web1/www.user.com/admin/item/add.php on line 57

//////////////////////////////

TIA

[eelixduppy]

You are missing the parenthesis. The line should look like this:
$open_db.close();

[dreamcatcher]

Is it also missing the class operator?

$open_db.close;

Try:

$open_db->close();

dc