database weirdness

[eluser]DougW[/eluser]
I have my default database set up in database.php in config. I want a user to log in using a user table in that default database and THEN load that users's parameters for his own database to connect to. I can;t add the database connection parms in database.php because when that gets loaded I don't know them yet.

Can I set those parms to dummy variables, then reset them after I load the user's data and THEN connect to the DB in my model?

Is there a better way?

[eluser]tomcode[/eluser]
You can solve this by connecting to multiple databases, see Connecting to your Database, , section Manually Connecting to a Database and section Connecting to Multiple Databases.

[eluser]DougW[/eluser]
That doesn't actually work because the variables that I want to use for database host, name user and password don't exist yet. So when the class is instantiated I get warnings. I got around it by defining variables in index, then reassigning them after the user logged in THEn calling for a manual connection in the constructor of the model.

Thanks!