Need help organizing multiple sites with a common account table
I have a situation where I have 2 sites that are somewhat related. I was hoping to organize these sites as sub-domains within a parent domain and registration would create a "global" account for both.
The problem i'm having is how this user and account table should handled since site1 and site2 each has it's own database.
Or do I just forget about this and keep two separate accounts/users table?
Any help is greatly appreciated since i'm at a total loss as to how to make this work
you can have one user accounts table for both sites, but you should have suserSites table where you will manage who was access on which site
Are the two sites different web apps, for example a forum and a blog?
it is not a problem as long as you have access to database server from both sites