create an array from database - use the array to pull records

[lemonman]

Hello everyone.
Goal: Create an array from a database, then use that array to look through the database and pull records using properties gathered from the first array accordingly.
Situation:
I am creating a css representation of a football players, baseball player, hockey players ,lacrosse etc which will put each player in the proper position on the field...

Each 'Sport' is it's own database.

When I call the 'Football' databse, I populate an array using the 'position' column.
It figures out how many positions there are in the 'Football' database[i](mine includes all offense, defense and special teams, which turns out to be alot of positions......)[/i]
I sort the array by using [b]'[color=blue]asort[/color]'.[/b]
Now I have the following details from my database in an array:

[color=red][code]$retrieved_positions[0] = "Tackle";
.........
$retrieved_positions[20] = "Kicker";[/code][/color]


I want to create CSS  for each position in the following format:

[color=red][code]<div id="Tackle">  [b]lfirst player <br> second player <br>.... etc [/b]</div>[/code][/color]

I will move each position around as I please(using css) overtop of a football field or graphic of some sort.

I am able to get the first position filled properly but cannot seem to get anything  after the first div properly filled.
Here's essentially what im getting with the attached  attached code.
[i]
All the tackles are inside the proper div[/i]
[code]<div id="Tackle">  johnny <br> james <br> joey <br> </div>
<div id="kicker"></div>.......<div id="quarterback"></div>
[/code]
[color=red][b]!!all other positions/div with proper id are being displayed but are empty.......!![/b][/color]

I'm using a [color=blue]'while loop' [/color] and [color=blue]'mysql_fetch_assoc'[/color] to fill my divs but for some reason it only satisfies the first position in my datbase generated array......
I've tried to explain as best I can, if anyone can help, i'd appreciate it...

[b][i]Here's the complete code:
I'VE NOTED WHERE I THINK THE PROBLEM IS TOWARD THE BOTTOM OF THE PAGE[/i][/b]
[code]

<?php
// EVERYTHING UP TO THIS POINT IS FINE
// GET SPORTS POSITIONS
$retrieved_positions = array();
$sql_position_grabber = "SELECT *  FROM  {$_GET['league_table']} GROUP BY position" ;
$queryResource2 = mysql_query($sql_position_grabber, $dbConn);

$i=0;
$number_of_positions = mysql_num_rows($queryResource2); 
  while ($row = mysql_fetch_assoc($queryResource2)) {

$retrieved_positions[$i] = $row['position'];
  $i++;
 
}
//SORT THE POSITIONS
asort($retrieved_positions);



//TRY AND FILL THE DIV'S NOW
$table = " FROM  {$_GET['league_table']}";

$teamexplode  = $_GET['team'];
$remove_the_hyphen = " ";
$team = trim(ereg_replace('-', $remove_the_hyphen, $teamexplode ));
echo $team;
echo "<br><br>";
$where = " WHERE team like '$team' AND position !='' ORDER BY position";


$sql = "SELECT * " . $table . $where;

$queryResource = mysql_query($sql, $dbConn);
//CREATE THE SPORTS FIELD USING MY CSS
echo "<div id=\"";
echo $_GET['league_db'];
echo "_depth\">";

for ($i = 1; $i <= $number_of_positions; $i++) {
$j=$i;
echo $j;
//START POSITION DIV
echo "<div id=\"". $retrieved_positions[$i]."\">";
  //*********** HERE'S WHERE I THINK THE PROBLEM IS , WHY DOES IT ONLY FILL THE FIRST POSITION?
  while ($row = mysql_fetch_assoc($queryResource)) {

if ($row['position'] == $retrieved_positions[$j]){echo $row['player'];
echo ",";
echo $row['position'];
echo "<br>";
}

}

echo "</div>";


  }
  echo "</div>";
?>
[/code]