[SOLVED] order

[sstangle73]

is there a way to order a sql query by COL--LTC--CPT--1LT--SGT

[priti]

will you tell me what is COL--LTC--CPT--1LT--SGT.

 

sorry for been so stupid to ask you this.

 

thanks

[darkfreaks]

<?php
$rank= array(COL,LTC,CPT,1LT,SGT)

array_multisort(SORT_ASC,SORT_STRING,$rank);

mysql_query("INSERT  INTO table VALUES (1,2,3) ODER BY $rank");?>

[darkfreaks]

Actually this will work better:

 

 

<?php

mysql_query("INSERT  INTO table VALUES (COL,LTC,CPT,1LT,SGT) ODER BY ASC");?>

[sstangle73]

there just military ranks

 

i already have stuff in the db im wondering how to display it in a query.

[revraz]

Use a ID number

 

ID | Rank

1  |  Gen

2  |  Col

 

etc

[sstangle73]

so your saying when i add it do another colome RANK#

[sstangle73]

yeah that worked thanks