[RESOLVED] Array Sorting

[fean0r]

With the below array how can I sort it by: toggle (greatest), scorefor (greatest) and then scoreagainst (lowest) ?
Array
(
[0] => Array
(
[team] => 13
[scorefor] => 34
[scoreagainst] => 56
[toggle] => -22
)

[1] => Array
    (
        [team] => 14
        [scorefor] => 30
        [scoreagainst] => 60
        [toggle] => -30
    )

[2] => Array
    (
        [team] => 15
        [scorefor] => 69
        [scoreagainst] => 21
        [toggle] => 48
    )

[3] => Array
    (
        [team] => 16
        [scorefor] => 47
        [scoreagainst] => 43
        [toggle] => 4
    )

)

[Installer]

foreach ($array as $value) {
    $toggle[] = $value['toggle'];
    $scorefor[] = $value['scorefor'];
    $scoreagainst[] = $value['scoreagainst'];
}
array_multisort($toggle, SORT_DESC, $scorefor, SORT_DESC, $scoreagainst, SORT_ASC, $array);

[fean0r]

I keep getting the following errors

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 464

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 465

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 466

Warning: array_multisort(): Argument #1 is expected to be an array or sorting flag that has not already been specified in /home/c4sites/public_html/iicup/custom/admin.php on line 468

Line 462: $array=array($teams['group4']);
Line 463: foreach ($array as $value) {
Line 464: $toggle[] = $value['toggle'];
Line 465: $scorefor[] = $value['scorefor'];
Line 466: $scoreagainst[] = $value['scoreagainst'];
Line 467: }
Line 468: array_multisort($toggle, SORT_DESC, $scorefor, SORT_DESC, $scoreagainst, SORT_ASC, $array);

[Installer]

If this, or an array structured like this, is the array you want to sort:

$array = array(array('team' => 13,
                     'scorefor' => 34,
                     'scoreagainst' => 56,
                     'toggle' => -22), 
               array('team' => 14,
                     'scorefor' => 30,
                     'scoreagainst' => 60,
                     'toggle' => -30), 
               array('team' => 15,
                     'scorefor' => 69,
                     'scoreagainst' => 21,
                     'toggle' => 48), 
               array('team' => 16,
                     'scorefor' => 47,
                     'scoreagainst' => 43,
                     'toggle' => 4));

(and according to your first post, it is) then the code will work.

What is "$teams['group4']"? Apparently it's a one-dimensional array, unlike the one you posted.

[fean0r]

As you can see below I got the above echo from $teams['group4'] which is part of the the teams array which consists of $teams['group1'], $teams['group2'], $teams['group3'] & $teams['group4']

Could that be an issue?

# echo Array
echo ('<pre>'); print_r($teams['group4']); die();

[fean0r]

this is the full array

Array
(
    [group1] => Array
        (
            [0] => Array
                (
                    [team] => 1
                    [scorefor] => 38
                    [scoreagainst] => 52
                    [toggle] => -14
                )

        [1] => Array
            (
                [team] => 2
                [scorefor] => 47
                [scoreagainst] => 43
                [toggle] => 4
            )

        [2] => Array
            (
                [team] => 3
                [scorefor] => 39
                [scoreagainst] => 51
                [toggle] => -12
            )

        [3] => Array
            (
                [team] => 4
                [scorefor] => 56
                [scoreagainst] => 34
                [toggle] => 22
            )

    )

[group2] => Array
    (
        [0] => Array
            (
                [team] => 5
                [scorefor] => 16
                [scoreagainst] => 74
                [toggle] => -58
            )

        [1] => Array
            (
                [team] => 6
                [scorefor] => 44
                [scoreagainst] => 46
                [toggle] => -2
            )

        [2] => Array
            (
                [team] => 7
                [scorefor] => 49
                [scoreagainst] => 41
                [toggle] => 8
            )

        [3] => Array
            (
                [team] => 8
                [scorefor] => 71
                [scoreagainst] => 19
                [toggle] => 52
            )

    )

[group3] => Array
    (
        [0] => Array
            (
                [team] => 9
                [scorefor] => 48
                [scoreagainst] => 42
                [toggle] => 6
            )

        [1] => Array
            (
                [team] => 10
                [scorefor] => 54
                [scoreagainst] => 36
                [toggle] => 18
            )

        [2] => Array
            (
                [team] => 11
                [scorefor] => 50
                [scoreagainst] => 40
                [toggle] => 10
            )

        [3] => Array
            (
                [team] => 12
                [scorefor] => 28
                [scoreagainst] => 62
                [toggle] => -34
            )

    )

[group4] => Array
    (
        [0] => Array
            (
                [team] => 13
                [scorefor] => 34
                [scoreagainst] => 56
                [toggle] => -22
            )

        [1] => Array
            (
                [team] => 14
                [scorefor] => 30
                [scoreagainst] => 60
                [toggle] => -30
            )

        [2] => Array
            (
                [team] => 15
                [scorefor] => 69
                [scoreagainst] => 21
                [toggle] => 48
            )

        [3] => Array
            (
                [team] => 16
                [scorefor] => 47
                [scoreagainst] => 43
                [toggle] => 4
            )

    )

)

[Installer]

It works perfectly for me. With the array you gave in your last post:

$teams = array('group1' => array(0 => array('team' => 1, 
                                            'scorefor' => 38,
                                            'scoreagainst' => 52, 
                                            'toggle' => -14), 
                                 1 => array('team' => 2, 
                                            'scorefor' => 47, 
                                            'scoreagainst' => 43, 
                                            'toggle' => 4), 
                                 2 => array('team' => 3, 
                                            'scorefor' => 39, 
                                            'scoreagainst' => 51, 
                                            'toggle' => -12),
                                 3 => array('team' => 4, 
                                            'scorefor' => 56, 
                                            'scoreagainst' => 34, 
                                            'toggle' => 22)), 
               'group2' => array(0 => array('team' => 5, 
                                            'scorefor' => 16, 
                                            'scoreagainst' => 74, 
                                            'toggle' => -58), 
                                 1 => array('team' => 6, 
                                            'scorefor' => 44, 
                                            'scoreagainst' => 46, 
                                            'toggle' => -2), 
                                 2 => array('team' => 7, 
                                            'scorefor' => 49, 
                                            'scoreagainst' => 41, 
                                            'toggle' => 8), 
                                 3 => array('team' => 8, 
                                            'scorefor' => 71, 
                                            'scoreagainst' => 19, 
                                            'toggle' => 52)), 
               'group3' => array(0 => array('team' => 9, 
                                            'scorefor' => 48, 
                                            'scoreagainst' => 42, 
                                            'toggle' => 6), 
                                 1 => array('team' => 10, 
                                            'scorefor' => 54, 
                                            'scoreagainst' => 36, 
                                            'toggle' => 18), 
                                 2 => array('team' => 11, 
                                            'scorefor' => 50, 
                                            'scoreagainst' => 40, 
                                            'toggle' => 10), 
                                 3 => array('team' => 12, 
                                            'scorefor' => 28, 
                                            'scoreagainst' => 62, 
                                            'toggle' => -34)), 
               'group4' => array(0 => array('team' => 13, 
                                            'scorefor' => 34, 
                                            'scoreagainst' => 56, 
                                            'toggle' => -22), 
                                 1 => array('team' => 14, 
                                            'scorefor' => 30, 
                                            'scoreagainst' => 60, 
                                            'toggle' => -30), 
                                 2 => array('team' => 15, 
                                            'scorefor' => 69, 
                                            'scoreagainst' => 21, 
                                            'toggle' => 48), 
                                 3 => array('team' => 16, 
                                            'scorefor' => 47, 
                                            'scoreagainst' => 43, 
                                            'toggle' => 4)));

and this code:

$array = $teams['group4'];
foreach ($array as $val) {
   $toggle[] = $val['toggle'];
   $scorefor[] = $val['scorefor'];
   $scoreagainst[] = $val['scoreagainst'];
}
array_multisort($toggle, SORT_DESC, $scorefor, SORT_DESC, $scoreagainst, SORT_ASC, $array);

echo '<pre>';
print_r($array);
echo '</pre>';

I get this output:

Array
(
    [0] => Array
        (
            [team] => 15
            [scorefor] => 69
            [scoreagainst] => 21
            [toggle] => 48
        )

[1] => Array
    (
        [team] => 16
        [scorefor] => 47
        [scoreagainst] => 43
        [toggle] => 4
    )

[2] => Array
    (
        [team] => 13
        [scorefor] => 34
        [scoreagainst] => 56
        [toggle] => -22
    )

[3] => Array
    (
        [team] => 14
        [scorefor] => 30
        [scoreagainst] => 60
        [toggle] => -30
    )

)

[Installer]

Now I see your mistake. In your code, this line (462):

$array=array($teams['group4']);

should be:

$array = $teams['group4'];

(It already is an array.)

[fean0r]

If I do the array manually (copy your) it work but using the one I had made it does nt..

$array = $teams['group4'];
foreach ($array as $val) {
   $toggle[] = $val['toggle'];
   $scorefor[] = $val['scorefor'];
   $scoreagainst[] = $val['scoreagainst'];
}
array_multisort($toggle, SORT_DESC, $scorefor, SORT_DESC, $scoreagainst, SORT_ASC, $array);
echo '<pre>';
print_r($array);
echo '</pre>';

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 467

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 468

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 469

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 467

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 468

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 469

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 467

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 468

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 469

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 467

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 468

Warning: Cannot use a scalar value as an array in /home/c4sites/public_html/iicup/custom/admin.php on line 469

Warning: array_multisort(): Argument #1 is expected to be an array or sorting flag that has not already been specified in /home/c4sites/public_html/iicup/custom/admin.php on line 471

Array
(
[0] => Array
(
[team] => 13
[scorefor] => 34
[scoreagainst] => 56
[toggle] => -22
)

[1] => Array
    (
        [team] => 14
        [scorefor] => 30
        [scoreagainst] => 60
        [toggle] => -30
    )

[2] => Array
    (
        [team] => 15
        [scorefor] => 69
        [scoreagainst] => 21
        [toggle] => 48
    )

[3] => Array
    (
        [team] => 16
        [scorefor] => 47
        [scoreagainst] => 43
        [toggle] => 4
    )

)

[Installer]

If I do the array manually (copy your) it work but using the one I had made it does nt..

But "my" array is exactly the same as the one you posted. That is to say, there is no difference.

This, with "my" array:

echo '<pre>';
print_r($teams);
echo '</pre>';

displays this:

Array
(
    [group1] => Array
        (
            [0] => Array
                (
                    [team] => 1
                    [scorefor] => 38
                    [scoreagainst] => 52
                    [toggle] => -14
                )

        [1] => Array
            (
                [team] => 2
                [scorefor] => 47
                [scoreagainst] => 43
                [toggle] => 4
            )

        [2] => Array
            (
                [team] => 3
                [scorefor] => 39
                [scoreagainst] => 51
                [toggle] => -12
            )

        [3] => Array
            (
                [team] => 4
                [scorefor] => 56
                [scoreagainst] => 34
                [toggle] => 22
            )

    )

[group2] => Array
    (
        [0] => Array
            (
                [team] => 5
                [scorefor] => 16
                [scoreagainst] => 74
                [toggle] => -58
            )

        [1] => Array
            (
                [team] => 6
                [scorefor] => 44
                [scoreagainst] => 46
                [toggle] => -2
            )

        [2] => Array
            (
                [team] => 7
                [scorefor] => 49
                [scoreagainst] => 41
                [toggle] => 8
            )

        [3] => Array
            (
                [team] => 8
                [scorefor] => 71
                [scoreagainst] => 19
                [toggle] => 52
            )

    )

[group3] => Array
    (
        [0] => Array
            (
                [team] => 9
                [scorefor] => 48
                [scoreagainst] => 42
                [toggle] => 6
            )

        [1] => Array
            (
                [team] => 10
                [scorefor] => 54
                [scoreagainst] => 36
                [toggle] => 18
            )

        [2] => Array
            (
                [team] => 11
                [scorefor] => 50
                [scoreagainst] => 40
                [toggle] => 10
            )

        [3] => Array
            (
                [team] => 12
                [scorefor] => 28
                [scoreagainst] => 62
                [toggle] => -34
            )

    )

[group4] => Array
    (
        [0] => Array
            (
                [team] => 13
                [scorefor] => 34
                [scoreagainst] => 56
                [toggle] => -22
            )

        [1] => Array
            (
                [team] => 14
                [scorefor] => 30
                [scoreagainst] => 60
                [toggle] => -30
            )

        [2] => Array
            (
                [team] => 15
                [scorefor] => 69
                [scoreagainst] => 21
                [toggle] => 48
            )

        [3] => Array
            (
                [team] => 16
                [scorefor] => 47
                [scoreagainst] => 43
                [toggle] => 4
            )

    )

)

which is exactly, to the letter, the same as what you posted.

[fean0r]

Yea I know!

Which leaves the question why wont mine work?

Perhaps I am not creating the array properly or something...

This is how I create my array:

if (($tcount >= 5) && ($tcount <= 8)) {
$teams['group2'][] =
 array (
'team' => $tcount,
'scorefor' => $scorefor,
'scoreagainst' => $scoreagainst,
'toggle' => $toggle,
);
}
# Group 3
if (($tcount >= 9) && ($tcount <= 12)) {
$teams['group3'][] =
 array (
'team' => $tcount,
'scorefor' => $scorefor,
'scoreagainst' => $scoreagainst,
'toggle' => $toggle,
);
}
# Group 4
if ($tcount > 12) {
$teams['group4'][] =
 array (
'team' => $tcount,
'scorefor' => $scorefor,
'scoreagainst' => $scoreagainst,
'toggle' => $toggle,
);
}

[fean0r]

Has anyone else got any ideas what might be the problem with the code?

[fean0r]

I found the problem

I needed to make some arrays before using the code:

$toggle=array();
$scorefor=array();
$scoreagainst=array();

$array = $teamx['group1'];
$toggle=array();
$scorefor=array();
$scoreagainst=array();
foreach ($array as $val) {
   $toggle[] = $val['toggle'];
   $scorefor[] = $val['scorefor'];
   $scoreagainst[] = $val['scoreagainst'];
}
array_multisort($toggle, SORT_DESC, $scorefor, SORT_DESC, $scoreagainst, SORT_ASC, $array);

[Installer]

That wouldn't make any difference. The arrays would be initialized the first time you use "$array_name[] = ...". Maybe the problem got fixed when you changed "$teams" to "$teamx"? At any rate, good for you.

BTW, you could replace all that code to create the array you posted earlier with this (inside your loop, of course):

$key = 'group' . ceil($tcount / 4);
$teams[$key][] = array('team'         => $tcount, 
                       'scorefor'     => $scorefor, 
                       'scoreagainst' => $scoreagainst, 
                       'toggle'       => $toggle);

[fean0r]

Nice one, Thanks for your help