I have a website which requires me to use multiple databases (all within the one msql account and all using the exact same script).
The reason being all the content for the main site and each subdomain are different and contained within the database so placing it all within the same single databse was not an option unless someone nows of a different method I could achive the same result.
As I have created all scripts (subdomain) to look exactly alike and for links to work together from 1 site to the other I have come across 1 major problem as each requires it's own admin panel to organise the fields/categories etc for each seperate site it has also seperated the registration and log-in process which means that to use each sub-domain a user would have to register to each one and then log-in to each one each time they click on a link that leads them to one of the other subdomains. Confusing isn't it.
What I am after is for someone who knows how to syncronize tables (namely the User tables) with all the other sub-domains which means their would only be 1 registration form on the main site which covers covers all the sub-domains and when a member is logged in and uses the site(s) he is still logged in throughout the whole usage experience/time.
I may be wrong if in thinking this can be done using msql sync and if so can anyone help with making this work.
I am not a programmer myself so this has become a nightmare for me although I can make small changes and html additions the rest is not in my capabilities.
Your help would be greatly appreciated and of cause you will be paid.