newbie - err 1046, no db selected

[wbrook]

(This is the continuation of this post - I started a new one because the subject wasn't clear. I edited it but it doesn't show up in the list of threads)

I am in the process of activating SSH on my account.

I can tell you that I connect OK to the db with PHP. In fact, I changed the username to a non-existent user to make sure connecting failed, and it does.

While waiting for SSH, I used myphpAdmin and in the SQL interface type use dbname and it works bt of course, I'm already in that database with I run the sql command. I also tried it with a non existent db and it fails as expected.

Anyone have any ideas on this?

Thanks.

[wbrook]

OK, I got SSH activated and tried theh command use dbname and it worked fine. I even did a desc on a table to make sure I was really usng that db, and it worked as well.

Any ideas?

[Ron]

Maybe best if you publish the code you're using (substituting the specifics (pw, username, dbname). Gotta be in the code if you can connect just fine in SSH.

[Ron]

Better yet -- try this code:

<?php
$dbhost = "localhost";
$dbname = "<JAGusername_database>";
$dbuser = "<JAGusername_dbUsername>";
$dbpasswd = "<dbUserPassword>";

$db_connect_id = mysql_connect($dbhost, $dbuser, $dbpasswd);
if($db_connect_id)
{
        print "connected<br>";
        $dbselect = mysql_select_db($dbname);
        if(!$dbselect)
        {
                print "Database not selected <br>";
        }
        else
        {
                print "Database selected <br>";
        }
        mysql_close($db_connect_id);
}
else
{
        print "not Connected <br>";
}
?>

EDIT: Fixed for consistency in substitution syntax in declarations.

[wbrook]

Thanks, Ron. It was a problem of scope. I had no idea that global variables weren't visible within functions.

Now it works.

[jason]

In order to use a global variable in a function you have to declare that they should be available in the function. To do that, use the global keyword:

function funName($arg1, $arg2, ..., $argx) {
   global $globalVar1, $globalVar2, ..., $globalVarX;
} 

or

function funName($arg1, $arg2, ..., $argx) {
   global $globalVar1;
   global $globalVar2;
   ...
   global $globalVarX;
} 

Of course, "good" programming standards discourage the use of globals because they are harder to keep track of in larger projects. But once in a while they come in handy.

--Jason

[Vin DSL]

Originally posted by jason
Of course, "good" programming standards discourage the use of globals because they are harder to keep track of in larger projects. But once in a while they come in handy.

--Jason

Funny you should mention that...

I turned off the 'globals' on my Nuke site a while back, when 'we' went to MySQL 4.x, and it's been running fine. I haven't found a need for them at all. Live 'n' learn, eh what?

[Gwaihir]

Turned off the globals??

Do you mean the register_globals directive? If so, that's quite a different - security related - matter.