Drop down form order of choices?

[Thundarfoot]

This form gets its choices from a table, except for first default choice ALL which is manual.

Is there a way to make the form default to a choice from the table, but still have the manual choice of All in the list?

 

Reason I want to do this is that currently when the page loads the default is to show all records this can be a waste of bandwith and time if user doesnt need to see All....here is the code...

Any help is very much appreciated.

[Thundarfoot]

 

<form id="form1" name="form1" method="post" action="">

  <label>Class

  <select name="select">

  <option value="">ALL</option>

    <?php

do { 

?>

    <option value="<?php echo $row_Class['Class']?>"><?php echo $row_Class['Class']?></option>

    <?php

} while ($row_Class = mysql_fetch_assoc($Class));

  $rows = mysql_num_rows($Class);

  if($rows > 0) {

      mysql_data_seek($Class, 0);

  $row_Class = mysql_fetch_assoc($Class);

  }

?>

  </select>

  </label>

<input type="submit" name="submit" value="submit">

</form>