You'll have to assign some sort of order to them using an integer tag column
or something similar... and then order by that when you select....
That's my best suggestion.
-Brian
http://www.zaam.com
""Peter Houchin"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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! **************
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
