Connection Question

[Anon]

Can anyone help me out with the following, I am wanting to connect to a database which has several password protected tables within it

DBHOST = "Bob"
DBUSER = "Bob1"
DBPASSWORD = "Bob2"
DBDATABASE = "Bob3"
user = "Bob4"
table = "Bob5"

I am only used to using the following

//Create connection
$connection = mysql_connect("bob","bob1","bob2") or die ("Couldn't connect to database");

//Select Database
$db = mysql_connect("bob5", $connection) or due ("Couldn't select database");

Any ideas?

[Anon]

Use mysql_select_db() to select a database - don't use mysql_connect. Also, your database name is Bob3, not Bob5. Bob5 is your table, which you use in the SELECT query, as in:
SELECT * From Bob5

Diego

[Anon]

So the code should look like this?

//Create connection
$connection = mysql_select_db("bob","bob1","bob2") or die ("Couldn't connect to database");

//Select Database
$db = mysql_select_db("bob4", $connection) or due ("Couldn't select database");

Then reference the table within SQL right?

I am getting the following error:
Warning: Wrong parameter count for mysql_select_db()

Any ideas?