[EST]

I got a problem when selecting database
This is the code that won't work

PHP Code:

$dbname = 'databasename';



mysql_select_db($dbname); 

This code is works

PHP Code:

mysql_select_db('databasename'); 

I don't know what the problem is, howcome if setup the variable for database's name it unable to select database? can someone tell he how to setup one?

[Caimin]

Weird - is that the whole code, or is there something before or after it?

[EST]

that's not the whole code, here is the complete one

PHP Code:

<?php

$dbhost = 'localhost'; 

$dbusername = 'user'; 

$dbpassword = 'password'; 

$dbname = 'databasename'; 



//Connection Function

function db_connect()

{

   @ $db = mysql_pconnect($dbhost, $dbusername, $dbpassword); 

   if (!$db)

    {

      echo 'Could not connect to database, Please try again later.';

      exit;

    }

   @ $select = mysql_select_db('databasename');

   if (!$select)

    {

      echo 'Error: Cant select database.';

      exit;

    }

}

?>

some people said it should be like this
but i've tried it, still won't work

PHP Code:

mysql_select_db($dbname, $db); 

and i call this from other script throught function db_connect()

[Ryan]

This is the code I use to connect to databases:

PHP Code:

<?php

$db = mysql_connect("serveraddy", "username", "password") or die(mysql_error());



mysql_select_db("dbname", $db) or die(mysql_error());

?>

[ealmiladi]

Dude....

PHP Code:

<?php

$dbhost = 'localhost'; 

$dbusername = 'user'; 

$dbpassword = 'password'; 

$dbname = 'databasename'; 



//Connection Function

function db_connect()

{

   @ $db = mysql_pconnect($dbhost, $dbusername, $dbpassword); 

   if (!$db)

    {

      echo 'Could not connect to database, Please try again later.';

      exit;

    }

   @ $select = mysql_select_db('$dbname');

   if (!$select)

    {

      echo 'Error: Cant select database.';

      exit;

    }

}

?>

Try that.....