[SOLVED] include db connection?

[ballhogjoni]

How would you include the db connection info into another file? example:

 

<?php
$username="xxxx";
$password="xxxx";
$database="xxxx";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_close();
?>

 

<?php
include("xxxx.com/tests/xxxxx/config.php");
// the rest of the code
?>

 

for some reason this is not working dfor me. where am i going wrong?

[per1os]

First off don't just supress errors with the @ sign, not very good especially when debugging.

 

Second localhost needs to be surrounded by quotes IE:

 

<?php
mysql_connect('localhost',$username,$password);

[Caesar]

Third, it's better practice to use a relative path when calling up that 'config.php' file :-P

[ballhogjoni]

Ok, Thanks. How do i unspress the errors? and any other ideas because just adding the quotes dint work.

[per1os]

Remove the @ sign from the front of them.

[ballhogjoni]

I appreciate your input, but it still dint do anything.

[papaface]

Remove mysql_close();

 

You are closing the connection.

[ballhogjoni]

Third, it's better practice to use a relative path when calling up that 'config.php' file :-P

 

This is what made it work. Thank you all for you help.