php/mysql compare arrays

My question: I got a phpmyadmin database ( and using php 5), with 2 tables to compare a football toto tournament. the strings that i must compaire are like the following :

1|2|3|1|1|2|3|1|2|3|3 

( in total 43 numbers) i know that i must use explode for taking out the "|" between them (because its saved as a string) but 开发者_JAVA技巧the final score is also saved like that. so i must compare all (guessed outcomes from matches with the final score string. how do it do it so that i can see who has got the most guessed right?

And that it would be shown as 1e place, 2e place, 3e place and so on?

Would be a great help, sorry if i lack at something.

I'm not entirely certain that I understand the question correctly, but if the two arrays are of the same length, you can use the same iterator for both of them.

After you've explode()d the strings into arrays:

$one = array(1, 2, 3, 4, 5);
$two = array(8, 2, 3, 6, 1);

$results = array();
for ($i = 0; $i < count($one); $i++) {
    $results[$i] = $one[$i] - $two[$i];
}

Note that the above code is untested, and instead of whatever calculation you use, I just subtract the value of each $two element from each $one element.

Hope it helps.

if i understand the question well...

$guess = array(1, 2, 1, 3, 1, 2, 3);
$real = array(2, 2, 1, 2, 2, 1, 1);
$score = 0;
$length = count($real);

for($i = 0; $i < $length; $i++) {
  if($guess[$i] == $real[$i])
    ++$score;
}

echo $score;