ERROR 1040: Too many connections

[osusano]

why im getting this kind of error?

dont know how to fix this?

i have my own linux box and with mysql and php..

i do use php for the script to get connected to the database and display all the values on the browser.

here's my connection script

  $dbservertype = "mysql";
  $dbservername = "localhost";
  $dbusername = "root";
  $dbpassword = "root123";
  $dbname = "data";

  if (!mysql_connect($dbservername,$dbusername,$dbpassword)){
    displayErrorPage("Cannot connect to ".$dbservername."!");
    exit;
  }
  if (!mysql_select_db($dbname)){ 
    Header("Location:index.php"); 
  }

is there somethign i need to do?

this is how i connect from my page

include "connect.php";

[steadyguy]

mysql_close() at the end of the script? Maybe you're connections aren't being dropped automatically.

[osusano]

you mean i need to put mysql_close() on each script with include "connect.php"; or just in connect.php?

[steadyguy]

If you need to access the database more than once per script, you'll need to put it in all the 'parent' scripts. Otherwise you can put it in connect.php.

A more elegant solution would be to put the connection script into a function, then close the connection at the end of the function. You'll be able to connect whenever you need to, but won't have to worry about connections not being dropped.

[Weedpacket]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10250594&highlight=Too+many+connections