Re: What is happen to MYSQL_CONNECTION?????

[Daini Dani]

Dear,

these are the answers:

Q.What o/s is running on the server ?
A. Red Hat Fedora Core 2 OS

Q.Which versions of MySQL & PHP ?
A. PHP Version 4.3.11

Q.How many users are accessing the site ?
A. Over 7000 users daily.

Q. When you are experiencing problems with the website, are you able to connect to MySQL from the command line ?
A. The problem still about 20 minutes and maybe about 5 hours.
And some days it doesn't appear!!!!
When there is a problem, I cann't connect using command line.

Q.What exactly is the error message and number that you get ?

I use this code to make a connection:

/////////////////////////
include "db.php";
$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting.");
mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");
$r=@mysql_query("Select dat from Tabl1 where dat=6",$db); // The result is 1 record.
$r=@mysql_fetch_array($r);
.
.
/////////////////////////