Menu
Community /Pin to ProfileBookmark
@NogDogJul 07.2006 — #The best solution would be to have the script that updates the confirmed value in table 2 to then delete any applicable entry from table 1. Otherwise, as the number of confirmed entries in table 2 grows, you'd be checking for more and more email addresses in table 1 that have already been deleted.
How to reconcile two files of different tables and databases
I installed a newsletter script with these fields in a table: ’email’ and ‘Email’ that have identical values.
I need to reconcile the values of two fields from different tables and databases by removing entries of one db upon change of values at the other table. I’m familiar to MySQL commands but not skillful with PHP.
In one table (users) and database (one)
[INDENT] MemberId
UserName
PassWord
Email[/INDENT]
in another table (members) of another database (two)
[INDENT]id
email
confirmed[/INDENT]
[COLOR=Green]If the value of the field ‘confirmed’ of db_two tbl_two changes from its default one, then the entry of the MemberId of the tbl_users of db_one is removed if Email/user/one matches email/members/two.
Can a php script update the first db if I simply open it from an Internet browser?
Would it be a loop that goes through every ‘id’ entry of the db two and that checks the value of the field ‘confirmed’ for every matched ’email’ and removes the entry ‘MemberId’ of the db one?
Thank you.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogJul 07.2006 — #