managing users

is there a script out there that will let me use one application but depending on there group id use different databases? the databases are the same format but i want to keep everyone's data seperate.

example:

group: abccompany
db_name: abccompany

group: xyzcompany
db_name: xyzcompany

Well, all you need to do is select the proper database for the proper group. Should just be an if/else situation, or you could use a switch statement. How are you determining what group someone is in?

i have a table in the database called groups and in the groups table i have:

g_name
g_admin
g_status
g_host
g_dbname
g_dbuser
g_dbpass