I'm still new to PHP and MySQL, and I normally fumble around with
a problem for quite a while before asking for help, but I'm trying to
save some frustration this time.
I have a MySQL database of several thousand customers. I need to
bring the names/addresses/etc. into an address verifyer and bulk-
mail sort program. This program does not support MySQL. I can
successfully export the fields I need to a .csv file, and import that
into the mail program. Once the mail program cleans the addresses,
I can then export the now clean data into another .csv file.
Now, what's the best way to bring the now updated (cleaned) data
back into the original MySQL database?
Should I import the data into a temporary table, and then step
through it, record-by-record, and do an update on the original table,
matching up the customer numbers?
Should I import the data into an array, and step through it from
there?
Do I simply do a REPLACE where the new customer # matches the
old customer #? There is still data in the original table that was not
exported.
Comments, suggestions, books, and/or examples would be
appreciated!
Thanks.
Malcolm
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
