[PHP] Arranging lists

[Peter Houchin]

Hi, 

I've got a select box that gets vaules  from a DB, now I want these value to be 
displayed in a certain order that's NOT relating to their id nor in alphabetical order 
.. can some one suggest a way this might be done??

At present my select box looks like this :

<form name="select"     method="post" action="machine.php">
<select name="system" size="1">
              <?php
  $query ="SELECT DISTINCT system FROM 1machine ORDER BY system";
  $result = mysql_query($query);
 
  while($row = mysql_fetch_array($result)){
    echo '<option value="'.$row[system].'">'.$row[system].'</option><br>';
  }
?>
            </select>
<input type="submit" name="select" value="select">                      
</form> 

Peter Houchin
[EMAIL PROTECTED]
=========================================================
     _____                              __   /\
    /_/_/_\                            /  |_/  \
   /_/_/_    __  __  __   __          /         \
   \_/_/_\  /_/ /_/ /_/  /_/          \   _     /
 ___\_\_\/ /_/_/_/ /_//\/_/            \_/ \/\_/
 \_//_/_/ /_/_/_/ /_/ \/_/                    v
     ________   ________________________________________
    /_/_/_/_/  /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   /_/_ _/_/ ______  __   __  /_/ ____      __     ______
  /_/_/_/_/ /_/_/_/ /_/  /_/ /_/ /_/\_\    /_/    /_/_/_/
 /_/  \_\  /_/ _/  /_//\/_/ /_/ /_/__\_\  /_/___ _\_\_\
/_/    \_\/_/_/_/ /_/ \/_/ /_/ /_/    \_\/_/_/_//_/_/_/
=========================================================
Telephone : (03) 9329 1455  Facsimile : (03) 9329 6755
************* We rent the dot in .COM!  **************