Hi,
Imagine this (lucky you only has to imagine it)...
I have a bunch of users (>500) who each have a two lists, A and B. These lists can be upto 200 lines long.
I need to compare a given user\'s list A with everyone elses list B and the same user\'s list B with everyone elses list A, and then display the matches.
To make it a bit more difficult, I need to compare them case insensitively and with non-alphanumeric characters removed, but I need to display them with the original data intact.
I originally did this in Perl with the lists in flat files iterating through the lists manually, which was fine with only a few users with small lists. For other reasons, I\'ve had to rewrite in PHP and have MySQL support.
At the moment, each person\'s lists are stored as one value in array delimited by newlines. So all I need to do is work out how to actually do the comparison thingy... any ideas?
Thanks in advance.
Oliver.
Imagine this (lucky you only has to imagine it)...
I have a bunch of users (>500) who each have a two lists, A and B. These lists can be upto 200 lines long.
I need to compare a given user\'s list A with everyone elses list B and the same user\'s list B with everyone elses list A, and then display the matches.
To make it a bit more difficult, I need to compare them case insensitively and with non-alphanumeric characters removed, but I need to display them with the original data intact.
I originally did this in Perl with the lists in flat files iterating through the lists manually, which was fine with only a few users with small lists. For other reasons, I\'ve had to rewrite in PHP and have MySQL support.
At the moment, each person\'s lists are stored as one value in array delimited by newlines. So all I need to do is work out how to actually do the comparison thingy... any ideas?
Thanks in advance.
Oliver.