Order fields

I have used the order fields to sort my db listing at the front end correctly. Unfortunately this orders the form number in first to last, I would prefer to oder the list by most recent first. (descending ?) but even better, is there some code that allows the user to sort the list in either ascending or descending order ?

jeff2

Hi jeff2,

Try field_name ASC or field_name DESC

Bob

How do you ORDER the list by a number from largest to smallest?

In one of my tables I have a miles driven field and the rank is not working. (see attached image)

Solved:

Changed table from VARCAR to INT.