Connecting to database won't work.

[pocobueno1388]

I am having trouble getting connected to my database. Here is the code I am using to do it:

config.PHP
-------------

<?php
$host = "localhost"; // your MySQL host i.e. the server on which the database is, usually localhost
$user = "*****"; // your MySQL username
$pass = "*****"; // your MySQL password
$db = "*****"; // the database to which you're trying to connect to

$conn = mysql_connect("$host", "$user", "$pass") or die ("Unable to connect to database.");
mysql_select_db("$db", $conn);
?>

Of course there are actual values stored in the variables other then the '*****'.

Is there something wrong with this script? I just use the code

include "config.php";

on the top of every script I need it with and it won't work. Any help would be appreciated. Thanks

[.josh]

change your code to this:
[code]
<?php
$host = "localhost"; // your MySQL host i.e. the server on which the database is, usually localhost
$user = "*****"; // your MySQL username
$pass = "*****"; // your MySQL password
$db = "*****"; // the database to which you're trying to connect to

$conn = mysql_connect("$host", "$user", "$pass") or die (mysql_error());
mysql_select_db("$db", $conn) or die(mysql_error());
?>
[/code]
and post the error message.

[joquius]

how about taking away the quotes from the string values? $db and not "$db"

[pocobueno1388]

Crayon Violent --> Here is the error I got with your code.

Can't connect to MySQL server on 'localhost' (10061)

joquius--> I got the same error when I took away the quotes.

Any other ideas?

[.josh]

looks like you are going to have to put your actual sql server name instead of localhost. you will have to rummage around in your host account for that info or contact your host.

[pocobueno1388]

Okay...I will hunt around for that information. Hopefully that is the only problem, I am anxious to get started on my new project.