[SOLVED] connection issue help ....

[imarockstar]

I am getting this error .. i have  never gotten this error before and It just started happening ..

 

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/tourzag/public_html/scripts/settings.php on line 7

Could not connect to MySQL: Too many connections

 

code ->

 

<?php


$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die('Could not connect to MySQL: ' . mysql_error());
mysql_select_db (DB_NAME) OR die('Could not select the database: ' . mysql_error());


include(dirname(__FILE__).'/../includes/permissions.php');
//Relogin user if logged in..
if (isset($_SESSION['id']) && $_SESSION['id'])
{
$adsf = mysql_query("SELECT * FROM users WHERE id = '{$_SESSION['id']}'");
$_SESSION = mysql_fetch_assoc($adsf);
}

$permissions = new permission();


?>

 

 

 

[br3nn4n]

You have too many open connections to the database. Add a mysql_close() to fix it.

[imarockstar]

thats just weird that it happened all the sudden ..

 

is there a script that will tell you how many connections that you have and maybe even the IP of the connection ?

[imarockstar]

and do you ALWAYS need to close the mysql connection ? a the end of each page ?

 

or i mean ... every time you connect, do you need to end that page/script with a close ?

 

thanks

[BobcatM]

or i mean ... every time you connect, do you need to end that page/script with a close ?

 

That is always a good practice.

[imarockstar]

ok good deal ... !!! I will start doing that ..