title: MySQL Error "Too many connections"
body: <p>I am using MySQL 5.0 for a site that is hosted by GoDaddy (linux). </p>
  
  <p>I was doing some testing on my web app, and suddenly I noticed that the pages were refreshing really slowly. Finally, after a long wait, I got to a page that said something along the lines of "MySQL Error, Too many connections...", and it pointed to my config.php file which connects to the database.</p>
  
  <p>It has just been me connecting to the database, no other users. On each of my pages, I include the config.php file at the top, and close the mysql connection at the end of the page. There may be several queries in between. I fear that I am not closing mysql connections enough (mysql_close()).</p>
  
  <p>However, when I try to close them after running a query, I receive connection errors on the page. My pages are PHP and HTML. When I try to close a query, it seems that the next one won't connect. Would I have to include config.php again after the close in order to connect?</p>
  
  <p>This error scared me because in 2 weeks, about 84 people start using this web application.</p>
  
  <p>Thanks.</p>
  
  <p>EDIT:</p>
  
  <p>Here is some pseudo-code of my page:</p>
  
  <pre><code> require_once('../scripts/config.php');
  
   &lt;?php
      mysql_query..
  
      if(this button is pressed){
         mysql_query...
      }
      if(this button is pressed){
         mysql_query...
      }
      if(this button is pressed){
         mysql_query...
      }
   ?&gt;
   some html..
   ..
   ..
   ..
   ..
   &lt;?php
     another mysql_query...
   ?&gt;
   some more html..
   ..
   ..
   &lt;?php mysql_close(); ?&gt;
  </code></pre>
  
  <p>I figured that this way, each time the page opens, the connection opens, and then the connection closes when the page is done loading. Then, the connection opens again when someone clicks a button on the page, and so on...</p>
  
  <p>EDIT:</p>
  
  <p>Okay, so I just got off the phone with GoDaddy. Apparently, with my Economy Package, I'm limited to 50 connections at a time. While my issue today happened with only me accessing the site, they said that they were having some server problems earlier. However, seeing as how I am going to have 84 users for my web app, I should probably upgrade to "Deluxe", which allows for 100 connections at a time. On a given day, there may be around 30 users accessing my site at a time, so I think the 100 would be a safer bet. Do you guys agree?</p>