[PHP/mySQL] Question

[Trigs]

When selecting a database using mysql_select_db(), can you use the function more than once and still retain the previous database selection? For example, can I do:

mysql_select_db('abc');
mysql_select_db('def');

Would that select both databases or would it select abc then select def?

[Protege]

I believe you would need two instances of a mysql connection active in order to connect to two databases simultaneously.

[Fehm]

Ya know what i'd do, have 2 config files and have

include ('config.php');
include ('config2.php');

Lol
Dunn of it would work though

[Agnostic Bear]

When selecting a database using mysql_select_db(), can you use the function more than once and still retain the previous database selection? For example, can I do:

mysql_select_db('abc');
mysql_select_db('def');

Would that select both databases or would it select abc then select def?

abc then def, if you wanted only 1 mysql connection, you could do it with a bit of overhead, you have 2 functions, i.e "mysql_select_2" "mysql_select_1" and you put this in each:

mysql_query('USE `databasename`'); 

then run the query.

[Trigs]

So wouldn't I just be better off doing something like:

mysql_query('USE db1 SELECT * blah blah blah');
and
mysql_query('USE db2 SELECT * blah blah blah');

[Agnostic Bear]

So wouldn't I just be better off doing something like:

mysql_query('USE db1 SELECT * blah blah blah');
and
mysql_query('USE db2 SELECT * blah blah blah');

No, however you can simply omit the mysql_select_db and do this:

SELECT * FROM `databasename`.`tablename`

[Trigs]

Thats much better. Thanks.

[Trigs]

Also, 2 more questions.

1. I created a function. Heres the code:

function clean($str) {
 if(!get_magic_quotes_gpc()){
     $str = addslashes($str);
    }
 $str = strip_tags(htmlspecialchars($str));
 return $str;
} 

Thats in config.php. If I include index.php and call that function I get an error saying that I can't redeclare it. I've never gotten that error before and all the other functions I created work.

And lets say I have these files

-MainFolder
--config.php
-SecondaryFolder
--index.php

How should I include config.php into index.php? Should I spell out the whole url?

[Trinity]

And lets say I have these files

-MainFolder
--config.php
-SecondaryFolder
--index.php

How should I include config.php into index.php? Should I spell out the whole url?

include '../config.php'; 

[Trigs]

tried that already. didnt work. maybe theres something in php.ini or apache's settings?