table 'foo.foofoo' doesn't exist

[twobyfour]

i am trying to include a config file for another script but it keeps trying to use the previous config file for the script. how can i require both of them on the same page.

PHP Code:

require ("config.php");
require ("config2.php"); 


does not work. it produces this "table 'foo.foofoo' doesn't exist"

[_Aerospace_Eng_]

We need to see what is in those config files. Remove any sensitive data before showing us though.

[twobyfour]

config.php

PHP Code:

//set up the names of the database and table
$db_name ="_";

//connect to the server and select the database
$server = "_";
$dbusername = "_";
$dbpassword = "_"; 


config2.php

PHP Code:

$username = "_";
 $password = "_";
 $hostname = "_";
        
 $dbname = ""; 


ofcourse each var is different

[twobyfour]

i got it fiqured out,

i had to close the connection to the first table, open a new connection to the second table and close it, then had to reopen the first connection to continue the rest of the script.