Gathering information from one mysql Database and storing in a differant DB

[big-dog1965]

Don’t know exactly how to describe what I want to do or if it is even possible, but here it goes.

I have a couple of different forms that the data is placed into mysql. Let’s call the databases form1 with a table of formtable1 and form2 with a table of form2table2. Then I have a database called gatheredinfo with a table allforms.

What I want to do is gather all information from database form1 and or form2 as it is submitted and copy it to database gatheredinfo.

This copied data will be compared to the data in gatheredinfo for instance First_name, Last_name, IP_Address, and so on. If it finds lets say First_name it looks for Last_name if there is not a match it adds the data. If it finds the data it then looks at the rest of the fields and if all are matched it don't add anything. If any of the fields are different then it adds the different data to that field.

So maybe in gatheredinfo you might see

First_name        Last_name        IP_Address

Bob                  Smith              65.120.1

Joe                  Blow                51.258.2

                                              45.357.3

 

[mpharo]

If they are stored in 2 different databases you will need to create 2 database connections, then just deal with the arrays seperatly and compare them...