Advanced Order By?

[Shawazi]

Using PHP loops I have a screen print something like this:

1) Owners [1
1) Management [1
2)Manager [1
2)Supervisor [2
1) Programming [1

The table has a column called tier which corresponds to the #)'s, which are updated via the loop. Another column is the_order which is updated via select fields and it corresponds to the [#'s. Does anyone know some way using group by or something of that nature with to have a select field print out the results in that order.

$query = "Query in question";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
   echo "<option value=\"$row[id]\">$row[name]</td>";
}

[thorpe]

Just order by the_order?

SELECT * FROM tbl ORDER BY the_order;

Im sure this is much too simple but the description of your problem isn't very clear.