I have two separate databases that have client info in them, one is mysql and the other is in MSSql. I need to send an email to them about the info in the db. The problem is that the email address is in the MSSql db and the info they need to change is in the mysql db. There is a common field between the two which is their customer number.
I have control over both boxes, and was thinking I would just export both of them and combine them into one database that has all the info in it, and then send the email out, but thought I'd see what you gurus thought about it. Here are a few more specifics: MSSql contains the email address and the customer contact info. Mysql contains the contact's client list and customer number. The info we need to send them is the NCOA and CASS (address change/correction) info from the USPS. The only common field between the two is the customer number. So we have customer #100 and he has 30 bad addresses in the mysql database. I want to make a script that will grab the 30 bad addresses and email it to the client to tell them to update it. The script shouldn't be too hard, I'm just wondering the best way get to the data. Ash _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
