mysql connection problem

lorddraco98

this is a really stupid question and this is the only script I've wrote where I've had this problem, but mysql_connect isn't working right for me. If I call it like the following, it works:

 mysql_connect("localhost","user","pass");

but if I try this, it wont connect:

require("./config.php");
mysql_connect($host,$user,$pass);

config.php file:

$host="localhost";
$user= "user";
$pass= "pass";
$db="db";

I've tried this on different servers and I keep getting access denied for user root (USING Password NO). I've also tried defining the variables right before the connect call and that doesn't work either, so it's not a problem with the included file.

It also does the same when selecting the DB. I can select it through

mysql_select_db("db");

but not through

mysql_select_db($db);

any ideas? this is really annoying me

musicbase

Have you got <?php and ?> tags around the code in config.php?
You must have these.

Richard

raspberryh

Hmmm... If you do echo $db does it echo the name of the database correctly?

lorddraco98

musicbase wrote:
Have you got <?php and ?> tags around the code in config.php?
You must have these.

Richard

yep, sorry. I got lazy and didn't post the whole code.

also, I can echo out all the variables and they show fine. This is why I'm so confused here, by all rights it should be working 🙁

raspberryh

Oh, I just saw a post like 1 minute ago where the fix was this:
instead of doing

mysql_connect($host,$user,$pass);

the person did

mysql_connect("$host","$user","$pass");

(and same for select db)
And they said it fixed it. I have no idea why, I personally have never had to do that, but maybe you could try it.
Heather

musicbase

raspberryh wrote:
Oh, I just saw a post like 1 minute ago where the fix was this:
instead of doing
mysql_connect($host,$user,$pass);
the person did
mysql_connect("$host","$user","$pass");
(and same for select db)
And they said it fixed it. I have no idea why, I personally have never had to do that, but maybe you could try it.
Heather

Ah yes now I look at it that's how I do it. I believe it must be because when you define a variable it doesn't include the quotes around it, and the mysql connect must have the quotes (If this makes any sense to you whatsoever? 😃)

Did it work?

lorddraco98

musicbase wrote:
Ah yes now I look at it that's how I do it. I believe it must be because when you define a variable it doesn't include the quotes around it, and the mysql connect must have the quotes (If this makes any sense to you whatsoever? 😃)

Did it work?

no luck 🙁 that does make sense though. I think there must be something wrong in my script because I just made a clean file in a different directory and it worked fine. I guess I'll just take a fine-tooth comb to my code hehe.

musicbase

$server = "your_server";	// server to connect to.
$database = "your_db";
$db_user = "your_username";
$db_pass = "your_password;
$link = mysql_connect("localhost", "$db_user", "$db_pass");
mysql_select_db("$database", $link);

This is the code I use - Any luck if you split this into the two files? It definately works when it is all next to eachother in one file.