mysticalfairy — Mon, 19 Dec 2005 18:30:59 +0000

I agree with Neutron2K

Neutron2k — Tue, 13 Dec 2005 15:13:24 +0000

that sounds like a very complicated system and i don't think you have thought it through correctly.

You shouldn't really assign everyone a new database because you could have hundreds of people using it. I suggest reading up on Database Relationships and structuring and finding a way to develop it on that principle using only one database.

It would be more efficiant that way for starters. Also don't foget that unless your on your own web server, your host will restrict how many mysql database you can have because they won't want to clutter up their server.

HOWEVER, if you are talking about just having your own seperate database for a set of fixed users (ie a total of 5 in this case), you can manually create the databases from phpmyadmin and duplicate them in there. Then at runtime decide which type of user is logged in and modify the connection string accordingly.

sorry if this is a bit techo mumbo jumbo.

I'm not entirley sure which way you are attempting to do things.