RE: Apache + php + MYSQL

2002-05-22 Thread Reynaldo Valera
Hi, try to use phpinfo()... it will list all php configuration and support modules. -Original Message- From: Sameer Maggon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:37 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Apache + php + MYSQL Hi, How do i

Re: Apache + php + MYSQL

2002-05-22 Thread Sameer Maggon
Hi, How do i check whether PHP has MYsql support built or not Please help Sameer -- you wrote: On Tuesday 21 May 2002 09:51, Robert Vetter wrote: > On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: > in /var/www/html/rcmms/appl.php on line 5 > > Hello, > > 1. make shure the PHP module is

Re: Apache + php + MYSQL

2002-05-21 Thread Reid Sutherland (mysql)
Jay Blanchard wrote: > [snip all kinds of stuff] >$query = "SELECT * FROM appl"; > $connection = mysql_connect("linuxsrv", "sameer", "sameer"); > mysql_select_db("rcmms", $connection); > $result = mysql_query($query, $connection); > ?> > I says that mysql_connect > > Fatal error: Call

RE: Apache + php + MYSQL

2002-05-21 Thread Jay Blanchard
[snip all kinds of stuff] I says that mysql_connect Fatal error: Call to undefined function: mysql_connect() in /var/www/html/rcmms/appl.php on line 5 [/snip] Try... Connections first, database selections next, then queries and results. If you get an "undefined function" now there is no MyS

Re: Apache + php + MYSQL

2002-05-21 Thread Robert Vetter
On Tuesday 21 May 2002 09:51, Robert Vetter wrote: > On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: > in /var/www/html/rcmms/appl.php on line 5 > > Hello, > > 1. make shure the PHP module is compiled into Apache, or runs as CGI. rubbish, sorry. Make shure PHP is compiled with MySQL support.

Re: Apache + php + MYSQL

2002-05-21 Thread Robert Vetter
On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: > Hi, > I have my Database in MYSQL and wanna use PHP on Apache > At the starting of the page I have given > >$query = "SELECT * FROM appl"; > > // Establish a connection to the MySQL DBMS > $connection = mysql_connect("linuxsrv", "sam

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-04 Thread Gary Bickford
In my case they appear to be left open indefinitely, until Apache is restarted. This is not what's supposed to happen, of course. I haven't tried tuning low_idle (I think that's what it's called, from the mysql_connect() doc at php.net). I probably should try that as well. I'm sure persis

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-03 Thread Paul DuBois
At 9:35 AM -0700 5/3/01, Scott Baker wrote: >That's very odd... Technically pconnect should be a lot faster, not >sure exactly why it's not. The other thing you might want to look >at is the MySQL idle timeout (or something like that). That's how >long your pconnects stay connected if they d

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-03 Thread Scott Baker
That's very odd... Technically pconnect should be a lot faster, not sure exactly why it's not. The other thing you might want to look at is the MySQL idle timeout (or something like that). That's how long your pconnects stay connected if they don't transfer any traffic. I think it defaults

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-03 Thread Gary Bickford
Thanks for the reply!, Scott! I considered changing the number of allowed connections but I figured this would just defer the problem, as the root problem was the increasing number of connections. Last night I went through the entire website looking for code that used mysql_pconnect() in PHP,

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-02 Thread Scott Baker
You can look into increasing the number of allowed connections that MySQL will accept... are you using connect or pconnect? At 04:23 PM 5/3/2001 -0700, Gary Bickford wrote: >Repost - nobody has any ideas? I've run some stress tests, sending >several thousand page requests, and the number of mys

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

2001-05-02 Thread Gary Bickford
Repost - nobody has any ideas? I've run some stress tests, sending several thousand page requests, and the number of mysql processes goes up and down but over time continues to rise. It's up to about 22 now. When it gets to about 30, every request from the web server will be will fail. Cou