Delimited Text File Database
Posted on 2006-10-27
This is in an existing program so I have to stick with the delimited text file instead of using mysql, here is what I have and what I want to do. I tried numerous things, nothing worked as of yet:
I have 2 separate delimited text files, we will call one FILE1 and the other FILE2.
FILE1 has this type of format:
FILE2 has this type of format:
Here is what I am trying to do:
I want to open FILE2 and see if the FILE2 $email is in FILE1 of either $e1 $e2 $e3 $e4
IF SO then for simple sake make $e2 = "FOUND";
It just seems like I have to open FILE2, pull out the $email, then open the FILE1 and check to see if there is a match, if yes then $e2 = "FOUND"; if not then go to FILE2 and get the next $email. I either crash or it get stuck in infinite loop. It seems simple but also it seems like there will be quite a few iterations being done. HELP!!!!