Merging 2 fields/arrays

[Mutley]

Not sure what a suitable topic title would be,

 

I have 2 fields that are used to explode in to arrays, one is "Users" the other is "Points", they are both ordered so the position of the Points are of equal match to that user. For example:

 

Users:

1;7;5;3;6;2

 

Points:

10;12;8;11;8;9

 

So User '1' has 10 points, User '7' has 12 points.

 

What I wish to do is allocate a variable to the first 3 Users who have the most Points (1st, 2nd and 3rd) so I am able to display a message congratulating them on their winning place, then a message to everyone else after this, to let them know they've lost.

 

I need to basically order the arrays in relation to each other, just how would I do this so they don't muddle up?

 

Thanks in Advance,

Nick.

[premiso]

$users = '1;7;5;3;6;2';
$users = explode(";", $users);
$points = '10;12;8;11;8;9';
$points = explode(";", $points);
$cnt = (count($users)-1);
for ($i=0;$i<$cnt;$i++) {
    $userPoints[$users[$i]] = $point[$i];
}

print_r($userPoints);

 

Give that a try. There might be a better way, but that should work.

[Mutley]

Thanks, premiso, so basically count the results from the explode then print them with the points by the side.

 

How would you reorder them by Points descending?

[tivrfoa]

you can use associative array like:

 

$userPoints = array(1 => 10, 
		   7 => 12, 
		   5 => 8,
		   3 => 11,
                           6 => 8,
                           2 => 9);

[premiso]

$users = '1;7;5;3;6;2';
$users = explode(";", $users);
$points = '10;12;8;11;8;9';
$points = explode(";", $points);
$cnt = (count($users)-1);
for ($i=0;$i<$cnt;$i++) {
    $userPoints[$users[$i]] = $point[$i];
}

rsort($userPoints);
print_r($userPoints);

 

sort look at the different sort commands.

[Mutley]

Cheers, just a few issues though, not sure if I understand this too well.

 

Firstly I removed the -1 from the count, as it was a single result too short.

 

It echos this with no "rsort":

Array ( [1] => [7] => [5] => [3] => [6] => [2] => ) 

 

Okay, now where are the points?

 

Now when I do use "rsort", I just numbers that are of no significance, like this:

Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) 

 

Finally, how do I call, say the first result of the array? I tried print_r($userPoints[1]); but got nothng, is this wrong?

 

Many thanks,

Nick.

[premiso]

    $userPoints[$users[$i]] = $points[$i];

 

Modify that part as it should be $points not $point. That was my mistake.

[Philip]

I'd use array_combine()

 

$users = '1;7;5;3;6;2';
$users = explode(";", $users);
$points = '10;12;8;11;8;9';
$points = explode(";", $points);
$array = array_combine($users, $points); // combine, use users as key, $points as value
arsort($array); // sort, maintaining the correct keys, from highest to lowest points
echo '<pre>';
print_r($array); // show what outputs
echo '</pre>';

 

Outputs:

Array
(
    [7] => 12
    [3] => 11
    [1] => 10
    [2] => 9
    [5] => 8
    [6] => 8
)

[premiso]

I'd use array_combine()

 

Yea, I guess I overlooked that when looking through the array functions Thanks.

[Mutley]

I see, now how could I attach a variable to the 1st array result? Say if I wanted to send a message saying "Congratulations, you've won!"?

 

Would it be possible to do something like:

 

Position => User ID => Score

Array
(
    [1] => [7] => 12
    [2] => [3] => 11
    [3] => [1] => 10
    [4] => [2] => 9
    [5] => [5] => 8
    [6] => [6] => 8
)

$winner=$array[6];
print_r($array[6]; // prints as.... '7'

 

[Mutley]

I've been doing a little reasearch and there are multidimensional arrays, I could also do a foreach to assing a variable to each position?

 

Anyone know more about multidimensional arrays or am I being over complicated?

 

Thanks in advance,

Mutley.