[PHP-DB] resolved : Re: [PHP-DB] too many connections?

2003-01-27 Thread Addison Ellis
i searched at mysql.com and it said basically what you are asking. i contacted the server admin and they are going to re-set the server. thank you for your time. best regards, addison Assuming that line 5 is the dbconnect, is there a limit on the number of connections that your MySQL server all

Re: [PHP-DB] too many connections?

2003-01-27 Thread 1LT John W. Holmes
> any idea what this means? i have not touched or changed my > config.php file since i put it up the first time... it contains my db > connect info. also, i just downloaded it from the server to see if it > had been modified and it had not. thanks again and best, addison > > Warning: Too many conne

RE: [PHP-DB] too many connections?

2003-01-27 Thread Cal Evans
What database are you using for your server? What OS is it running on? I've run into this on MSSQL before but never on MySql. =C= p.s. Hi from Antioch! * * Cal Evans * Stay plugged into your audience. * http://www.christianperformer.com * -Original Message- From: Addison Ellis [mailto

Re: [PHP-DB] too many connections?

2003-01-27 Thread John Krewson
This would make a whole lot more sense within a context...such as how busy is your application, what kind of connection you are using (pconnect vs. connect) and so on. A quick search on MySQL's web site resulted in: http://www.mysql.com/doc/en/Too_many_connections.html Be sure to check out ge

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-25 Thread Peter Beckman
You can also do something like this: if ($db_link = mysql_pconnect($host, $user, $pass)) { if (mysql_select_db($db,$db_link)) { return $db_link; } else die("MySQL Error: Cannot select {$db} database using {$user}@{$host}: ".mysql_error()); } else die("MySQL Error: Cannot connect to {$db}:

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-25 Thread dr. Agon
Helo, why you don't make some kind of "db_connect.php" which will make "mysql_pconnect()" and include it in top of your first script? You then will be able use mysql query in everyone of your page. You can also make $mysql_is_connected=true; there and check that variable in other scrips if nee

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-24 Thread Micah Stevens
Just open one connection. It'll work fine for multiple queries across several include files. I have a project right now that uses about 5 different include files at any one time, and 1 connection works great. Also keeping only one connection alive will speed up the script. -Micah At 09:14 PM

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-24 Thread Georgie Casey
Yeah, sometimes I open and close 2 or 3 permanent connections in one page. I knida have to as each page is made up of a few different include files, and if I dont do seperate connections, it mightnt work. I'll recode my site to cache everything except search pages, or can I even cache these as wel

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-23 Thread Duncan Hill
On Wed, Oct 23, 2002 at 10:18:07PM +0100, Georgie Casey wrote: > Im getting a too many connections error in my PHP pages at > http://www.free-ringtones.tv. I presume this is from the MySQL server, and I > know I access the database a lot for each page. So whats the solution to MySQL has a default

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-23 Thread Micah Stevens
Send me the code around the lines that are giving errors.. Doesn't look like a MySQL error to me. -Micah At 10:18 PM 10/23/2002 +0100, Georgie Casey wrote: Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I kno