dthomsen8
01-07-2010, 12:06 PM
I am helping someone else learn PHP and MySQL. I have forgotten much of what I know about those packages, but I know that MySQL is not difficult.
What I want is to compare two MySQL files, looking for matches in a certain key field, and then updating one of them with information from a matching record on the second file. For example, street addresses might be the key, no need for city or state because all are in the same city. After getting the street address matches (maybe with manipulation of the addresses to line up apartment numbers or the like), then to compare names in the files, too. This can be done by putting the names from the second file into the first file, and then making a run on the first file to compare and mark the matches.
The difficulty is that MySQL is designed to respond to a web page, not to run the procedural compares I am seeing to do. Any advice?
What I want is to compare two MySQL files, looking for matches in a certain key field, and then updating one of them with information from a matching record on the second file. For example, street addresses might be the key, no need for city or state because all are in the same city. After getting the street address matches (maybe with manipulation of the addresses to line up apartment numbers or the like), then to compare names in the files, too. This can be done by putting the names from the second file into the first file, and then making a run on the first file to compare and mark the matches.
The difficulty is that MySQL is designed to respond to a web page, not to run the procedural compares I am seeing to do. Any advice?