2d Array Help

[richie19rich77]

Hi All,

I am creating a sports league / results website.


I have a field called "Fixtures_ID" this field contains 14 items that varey from 1 to 14.  I also have a function that works out the number of points each team has.

Now I am first doing a selct statement on the Fixtures_ID getting all teams that are in the 1st division, this gives me the fixtureID for each team.

But I want the league table to be sorted by number of points, now I am trying to create a 2d array that contains the number of points and fixtureID, the items must say together as they are used for querying different items.

so array should look like:

Fixtures_ID  Points
1                  5
2                  8
3                  1
4                  2
5                  11

I can loop round on the select statement to put the fixtures_ID into an array, but I could also get the points the same way, but as soon as I sort the points array, it loses any connection to the Fixtures_ID

Fixtures_ID  Points
1                  1
2                  2
3                  5
4                  8
5                  11

But it should look like:

Fixtures_ID  Points
3                  1
4                  2
1                  5
2                  8
5                  11

So how would I creare a 2d array, and input into the 2d array within a loop of the Fixtures_ID,

I would like to do

For.......
  $array[$x][$y] = $FixturesID,$Points


$x looping on the fixtures and $y looping on the points.

Hope that makes sense.

Thanks

[doni49]

http://www.phpfreaks.com/forums/index.php/topic,114453.0.html

[sasa]

look natsort() function

[richie19rich77]

Thank you "doni49", that link worked a treat.

so basic and so easy.

[code]
$out = array ();

for ($x = 0; $x < $num_rows ; $x++) {
      $out[] = array ($x,$x);
}
[/code]

Thanks

[doni49]

Well I didn't do anything special.  I just knew that I had read that thread recently and knew what to search for.

[Psycho]

Is there a reason you just don't sort the records in your select statement?