PHP Condition within a loop - PHP

I have an array like this:

$team_scores = array('Tigers' => 3, 'Spikes' => 6, 'Crashers' => 8, 'Fortress' => 2);

created from a MySQL query in which names are from one column and values are from another column. I want to create a page for each team that should indicate the name of the team and its score as well as position. So in this example I would have 4 pages and each page shows the name and score for a team without showing any information about 开发者_Python百科other teams other than the total teams that participated. So it would show

Name: Spikes Score: 6 Position: 2/4,

For Crashers it would be

Name: Fortress Score: 2 Position: 4/4,

I am thinking a foreach loop would do but am only able to echo the teams and scores on a single page, when what I need is to create 4 pages, one for each item in the array. I am able to do that with data just being pulled from the database, but from such data I do not think its possible to determine the position of each team without having the data in one array.

Is that even possible or am I asking PHP to do what cannot be done? Any help will be deeply appreciated.

Don't do it in PHP. You want to use something like an ORDER BY clause in your SQL query to sort your results by score. You can then use a LIMIT on the query to only fetch one row at a time, and combine that with an offset to get exactly the row you need.

In MySQL you'd do:

SELECT 
   @position:= @position + 1 AS position,
   score_table.*
FROM 
   score_table,
   (SELECT @position := 0) p 
ORDER BY score;

Then you could do:

$count = count($results);
foreach ($results as $result) {
    echo "Name: {$result['name']}";
    echo "Score: {$result['score']}";
    echo "Position: {$result['position']}/{$count}";
}

If you want to do it in plain SQL (e.g.: compatible with other SQL databases), you'd do:

SELECT 
   *
FROM 
   score_table
ORDER BY score;

Then, considering you have numerically indexed $results:

foreach ($results as $key => $result) {
    echo 'Position: '.($key+1);
}

Use $_GET to figure out which team to display:

/teams.php?team=spikes
...
$i = 0;
$nbTeams = count($team_scores)
foreach ($team_scores as $team => $score)
{
   $i++;
   if ($team == $_GET[team])
   {
       echo "Name: $team Score:  $score Position: $i/$nbTeams";
   }
}