I need a PHP script that will compare line by line in my tables and from that comparison create another table.
Let me explain that in detail.
There will be 3 Tables. Tables can me txt or csv files. Which is easier for you.
Table one has 10 numbers in one line, like this:
Table 2 has 5 numbers lin line, like this:
and so on.
Table 3 is results table. It has 10 numbers in line. (first line is same as in Table1)
and this is how process goes.
You take Line 1 from Table 2 and compare it with Line 1 on Table 3
so you will take "1,2,3,4,5" from Table 2 and compare with "1,2,3,4,5,6,7,8,9,10" from Table 3...this will match because all numbers from Line 1 Table 2 are in "1,2,3,4,5,6,7,8,9,10". If there is match, you skip to next line in Table 2.
Take 2,5,8,9,10, compare it again to 1,2,3,4,5,6,7,8,9,10, and there is again match beacuse all numbers are in. Skip this line and go to next line.
Take 1,2,5,7,12, compare again to Table 3 Line 1 "1,2,3,4,5,6,7,8,9,10" and you will get mismatch, because numbers 12 is not in that sequence.
Then you take "1,2,5,7,12" and go to TABLE 1 and compare it with lines...first line will give mismatch, you skip it, second line will give mismatch, third line "1,2,3,4,5,6,7,8,9,12" will give match, and then you take that line "1,2,3,4,5,6,7,8,9,12" and write it into Table 3
So table 3 will look like this now:
and then you continue with same process until all lines in Table 2 are compared.
Let me know if you have any questions.
1 фрилансеров готовы выполнить эту работу в среднем за $8
We are interested to work with your situation and, I assure you, if you PROVIDE us the OPPORTUNITY, will prove our efficiency, reliability, IN TIME WORK DELIVERY and 100% ACCURACY !