This may seem like an off the wall question, but I am wondering if there is a way to have info duplicated/copied into another database upon entry in first database.
Basically, this is what I have. I have 2 different sites. One is for Doctors, the other is for Patients. There is a long questionaire that I want patients to be able to fill out on the patient website, but viewable by the doctors on the doctors website. So, I have two database, but the tables that I need to duplicate from/to are labeled the same in their corresponding database, and both databases are under the same cpanel.
I know I could accomplish this by adding an sql query to input data into second database, but wondering if there is a way within mysql that will allow me to do this.
Any help would be greatly appreciated. Thanks in advance.
