mysql_select_db problem

Stinger51

No matter what I do, I cannot get PHP to select more than one database. It only selects the one that I originally built after first installing MySQL.

I am running on a Windows platform using :

MySQL 3.23.47
PHP 4.3
Apache 1.3

Here's the code :

$db_name = "c:/mysql/data/testDB";

$conn = mysql_connect("127.0.0.1", USER_NAME, PASS_WORD) or die ("Couldn't connect.");

$db = mysql_select_db($db_name, $conn) or die ("Couldn't select database -- $db_name");

It fails every time at the last statement.

I can manipulate the DB from the MySQL monitor, so I know it's formatted properly. It's just that PHP will not select it!

I also had this same problem using PHP 4.1 (hence, I tried the upgrade to 4.3).

Any ideas here? I'm outta' em.

Tnx in advance.

bastien

thats not a db name., that looks like the physical location....in your admin panel, you should show the name of the db...

ie on my machine:

test
booths
gulfstream
sites

etc

it should hopefully be a one word name that describes the db, not a path to the physical location of the datafiles

hth

Stinger51

Thanks, I tried that too, but got the same result :

$db_name = "otherDB";

$conn = mysql_connect("127.0.0.1", USER_NAME, PASS_WORD) or die ("Couldn't connect.");

$db = mysql_select_db($db_name, $conn) or die ("Couldn't select database -- $db_name");

It still fails on the select.

Only the very first DB that I set up can be selected. In fact, PHP won't even select the "mysql" DB !

Really strange.

bastien

i usually use this code, in a separate file and simply require that file in whatever page i use the db in


    $vusername = "****";           //your username for you local system
    $pwd ="****";                      //password to accecss mySQL
    $host = "localhost";              //host is localhost - even for most web hosts
    $dbname = "test";                //db name to be accessed



    //connect to db
    //$conn=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

    if (!($conn=mysql_connect($host, $vusername, $pwd)))  {
        printf("error connecting to DB by user = $vusername and pwd=$pwd");
        exit;
    }
   $db=mysql_select_db($dbname,$conn) or die("Unable to connect to database");