php, use database that is a variable

bmac11

$query = mysql_query("USE $use_db");

In my php code, how can I USE a database that is a variable?

If I use the above, it says No Database Selected.

bodzan

$link = mysql_connect($DBServer,$DBUser,$DBPass);
mysql_select_db($DBName,$link);

So it's pretty much what you want to do selects a database that is named $DBName after it connects to the server in first line...

Is this helpfull?

bmac11

thanks for the reply.

It still wont connect to the database. For some reason I have to use the "USE" command in a mysql_query and not mysql_select_db.

I had this problem when I ran a test site on my machine. It wouldnt let me use mysql_select_db. Now this is on the webhost and need to call the database with a variable.

Any other suggestion?

Here's the rest of the code and how I connect to the server and db. I don't think its a very good way. Its the way I was shown in a book. I see other people's code around here and they do it differently. Maybe this is my problem.

$connect = mysql_connect("*****", "*****", "*****") or
	die ("Hey, check your server connection.");

//----------------------make sure we're using the right database--------------------
$query = mysql_query("USE $use_db");


//----------------------find max number of links in database-------------------------
$query = mysql_query("SELECT * FROM $linksinfo");
$num_of_links == 1;
while($row = mysql_fetch_array($query)) {
$searching_row = $row["entered"];
$num_of_links++;
}

bmac11

also,

$use_db is declared as

$front_db = "webhostuser_22_";

$use_db = "$front_db$topic_id";

echo "Use db= " . $use_db . "<BR>";

I dont know if it matters that it is composed of both an integer ($topic_id) and characters. I printed it out to see if its ok and it is infact the db name I want to select.