Im kind of new at php and I just have the hardest time with looping. I have a database that I want to put into separate HTML tables. If my database contained

Table: game
id___level___stage___name
1_____1_______2_____Jim
2_____3_______1_____Mark
3_____3_______4_____Jane
4_____2_______1_____Joyce
5_____1_______1_____Kim
6_____1_______1_____Matt
7_____3_______2_____Mike
8_____1_______3_____Steve

What I would like is for it to end up looking like this:

Level 1 - Stage 1

Kim
Matt

Level 1 - Stage 2

Jim

Level 1 - Stage 3

Steve

Level 1 - Stage 4

Level 2 - Stage 1

Joyce

Level 2 - Stage 2

Level 2 - Stage 3

Level 2 - Stage 4

Level 3 - Stage 1

Mark

Level 3 - Stage 2

Mike

Level 3 - Stage 3

Level 3 - Stage 4

Jane

I have this but it doesn't work that well.

$i=1;
$result = mysql_query("SELECT * FROM game ORDER BY level,stage");
while ($row = mysql_fetch_array($result)) {
$level=$row['level'];
$stage= $row['stage'];
$name= $row['name'];
if($level==$i){
print 'Level '.$level.' - Stage '.$stage'<br />';
$i++;}
print $name'<br />';
}

This does well for the first couple lines but then it stops printing the levels. I don't think that I did the correct thing and for the life of me I cannot figure this out. Any help would be great.
Thank you
Matt

If you remove the if() and always print both level, stage and the name then are they in the correct order?

In some cases maybe there will be a gap in level (for example not having anyone at lvl 4 but some at both 3 and 5)? Then this would be better.

PHP Code:

$pre_level = 0; // Assuming there is no level zero, if there is set it to -1 instead
$pre_stage = 0;
while ( ... ) {
   // some code here
   if ($level > $pre_level) {
      // print new level and new stage
      $pre_level = $level;
      $pre_stage = $stage;
   } elseif ($stage > $pre_stage) {
      // print same level again with new stage
      $pre_stage = $stage;
   }
   // print the name
}