Click to See Complete Forum and Search --> : Php/mysql Database Order Problem 2


domuk
06-02-2004, 05:49 AM
I would like to order the list below, but it does not follow any numeric or alphabetical order. There however is an order to the individual letters, which is as below:

M=0
D=1
Vd=2
Ms=3
S=4
Hs=5
Mvs=6
Vs=7

The letters are stored in the database. Is there a way to order these using sql without changing the data stored in the database?

DanUK
06-02-2004, 05:55 AM
EDIT, mistaken for something else. Sorry.