Re: Tables coping data to each other
OK I do get you now.
Lets forget it being a forum or other script then for now. I will discribe what I want the msql database to do in the best way I can based on 3 sites A, B & C talking only about a single table (site-prefix_filename) and all installed in the same database, using the same db-name, db-username & bd-password.
I am using cPanel and the database is phpMyAdmin.
Site A = hjy_members
Site B = dte_members
Site C = wts_members
Each one of these has the users registration details like Username, Password(Encrypted), registration date plus many other fields (all exactly the same).
When a new user registers on site A and the details are send to the db hjy_members table I need these same details to be automatically copied into site B dte_members table and site C wts_members table.
Same with if a member registers from site B then the details in dte_members need to be automatically copied/sent to hjy_members and wts_members tables.
This must work the same way all round no matter which site (*_members) they register from.
It must also allow for copies to be made to and from any new sites (D, E, F,etc).
The result must be that no matter what site a user registers from the database sends a copy of the details to all the other prefix_member tables within that same database_username & Password.
The user end result must be that they can log-in to any site deing A, B, C, D, E etc using the exact same log-in details.
I have done the best I can to discribe what I am after without using your kind of terms which I know nothing about. I know what i want and how I want it to work, the rest is up to the professionals to work out how this can be done.
I hope it's enough.
Subject
Written By
Posted
December 02, 2011 07:35AM
December 02, 2011 12:33PM
December 02, 2011 02:45PM
December 02, 2011 05:26PM
December 02, 2011 05:55PM
December 02, 2011 07:20PM
December 02, 2011 07:40PM
December 02, 2011 08:20PM
Re: Tables coping data to each other
December 02, 2011 09:19PM
December 02, 2011 09:51PM
December 03, 2011 12:08AM
December 03, 2011 01:34PM
December 03, 2011 01:59PM
December 03, 2011 02:22PM
December 03, 2011 04:27PM
December 03, 2011 04:41PM
December 03, 2011 04:46PM
December 03, 2011 07:13PM
December 03, 2011 07:53PM
December 03, 2011 08:32PM
December 03, 2011 04:52PM