error message

[ceanth]

hi all i get this error:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /homes/cghe11/public_html/members/db.php on line 11
Couldn't connect to server.

when i have this script:

<?
/ Database Information - Required!! /
/ -- Configure the Variables Below --/
$dbhost = 'localhost';
$dbusername = 'your_username';
$dbpasswd = 'your_password';
$database_name = 'your_database';

/ Database Stuff, do not modify below this line /

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");
?>

anyone know what is wrong?

[theeper]

Either your mysql server isn't running, or you are using a socket connection that is corrupt or missing. Or maybe, your mysql setup doesn't allow persistant connections.

[ceanth]

it worked the other day and isnt working now. I can seem to search from the database quite easily, but this errors occurs when i am adding to the database

[trooper]

Change the messages in the die statement to the followin

die(mysql_error())

that way you'll get more informative error statement

HTH

GM

Originally posted by ceanth
hi all i get this error:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /homes/cghe11/public_html/members/db.php on line 11
Couldn't connect to server.


when i have this script:

<?
/ Database Information - Required!! /
/ -- Configure the Variables Below --/
$dbhost = 'localhost';
$dbusername = 'your_username';
$dbpasswd = 'your_password';
$database_name = 'your_database';

/ Database Stuff, do not modify below this line /

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");
?>

anyone know what is wrong?