php & MySQL connection...
Hi All, me again, the noob 
I'm trying to connect to my MySQL database and use a simple select statment but am getting the following error returned:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
My php file looks like this :
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("username_pn", $con);
$result = mysql_query("SELECT * FROM subscriber");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";
}
mysql_close($con);
?>
I think its the 'localhost' parameters.
Can anybody shed any light on this?
Many thanks.
I'm trying to connect to my MySQL database and use a simple select statment but am getting the following error returned:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
My php file looks like this :
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("username_pn", $con);
$result = mysql_query("SELECT * FROM subscriber");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";
}
mysql_close($con);
?>
I think its the 'localhost' parameters.
Can anybody shed any light on this?
Many thanks.
When you activated MySQL you should have received an email giving the server name (rumpus or humbug), username and password.
