queries strings and time travel

[hinksta]

I have a query that uses ORDER BY
I would like it to order by a string that is made after some sub queries at the end of the query.
Is there a nice trick to do this or do I need to find a way to get the string made before the query?

[hinksta]

OK I think i'm starting to get this but have a couple of questions.

Is it a big problem with the array starting at 0 and my first team being 1?

Can you see what's up with my third print_r?

[PHP]$teampoints=$arraypoints;
$theteampoints = (array_count_values($teampoints));

print_r($team);
echo"<br /><br />";
print_r($theteampoints);
echo"<br /><br />";

$a1=($team);
$a2=$theteampoints;
print_r(array_intersect($a1,$a2));[/PHP]

Array ( [0] => Accrington Stanley [1] => Aldershot [2] => Altrincham [3] => Aylesbury United [4] => Barnet [5] => Barrow [6] => Bath City [7] => Boston United [8] => Bromsgrove Rovers [9] => Burton Albion [10] => Cambridge United [11] => Canvey Island [12] => Carlisle United [13] => Cheltenham Town [14] => Chester City [15] => Chorley [16] => Colchester United [17] => Crawley Town [18] => Dagenham [19] => Dagenham &...

Array ( [1 wins] => 28 [63 wins] => 8 [tie] => 121 [20 wins] => 16 [28 wins] => 8 [25 wins] => 18 [36 wins] => 22 [38 wins] => 13 [47 wins] => 22 [61 wins] => 19 [11 wins] => 15 [12 wins] => 13 [32 wins] => 21 [33 wins] => 21 [72 wins] => 17 [69 wins] => 14 [3 wins] => 10 [31 wins] => 13 [57 wins] => 10 [54 wins] => 9 [10 wins] => 16 [2 wins] => 16 [18 wins] => 12 )

Array ( )

[pbmods]

Heya, hinksta.

The 'problem' with the third print_r() is that there is no intersection between the two tables. PHP has no way of associating the values in the first array with the values in the second array.

Since you already have the team data, you don't need the first array. And since you need to know how many 'win points' you have per team, you'll want to incorporate the team IDs into your second array as the keys.

So for example, using this data:

Team 5 vs. Team 8: Team 5 wins.
Team 3 vs. Team 12: Team 12 wins.
Team 5 vs. Team 7: Tie
Team 8 vs. Team 12: Team 8 wins.

The goal is to end up with one array that looks like this:

array(
    5 => 4,  // One win and one tie for team 5
    8 => 3,  // One win for team 8
    3 => 0,  // No wins for team 3
    12 => 3, // One win for team 12
    7 => 1  // One tie for team 7
);
 

Then, using arsort(), you will end up with this:

array(
    5 => 4,
    12 => 3,
    8 => 3,
    7 => 1,
    3 => 0
);
 

In this case, you now know to display team 5 first, then team 12, then team 8, and so on.