Skip navigation links

MySQL Forums :: General :: Tables coping data to each other


Advanced Search

Re: Tables coping data to each other
Posted by: Philippe Desvaux ()
Date: December 02, 2011 09:19PM

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.

Options: ReplyQuote


Subject Written By Posted
Tables coping data to each other Philippe Desvaux 12/02/2011 07:35AM
Re: Tables coping data to each other Peter Brawley 12/02/2011 12:33PM
Re: Tables coping data to each other Philippe Desvaux 12/02/2011 02:45PM
Re: Tables coping data to each other Peter Brawley 12/02/2011 05:26PM
Re: Tables coping data to each other Philippe Desvaux 12/02/2011 05:55PM
Re: Tables coping data to each other Peter Brawley 12/02/2011 07:20PM
Re: Tables coping data to each other Philippe Desvaux 12/02/2011 07:40PM
Re: Tables coping data to each other Peter Brawley 12/02/2011 08:20PM
Re: Tables coping data to each other Philippe Desvaux 12/02/2011 09:19PM
Re: Tables coping data to each other Peter Brawley 12/02/2011 09:51PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 12:08AM
Re: Tables coping data to each other Peter Brawley 12/03/2011 01:34PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 01:59PM
Re: Tables coping data to each other Peter Brawley 12/03/2011 02:22PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 04:27PM
Re: Tables coping data to each other Peter Brawley 12/03/2011 04:41PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 04:46PM
Re: Tables coping data to each other Peter Brawley 12/03/2011 07:13PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 07:53PM
Re: Tables coping data to each other Peter Brawley 12/03/2011 08:32PM
Re: Tables coping data to each other Philippe Desvaux 12/03/2011 04:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.