2. PHPRunner General questions
  3. Ascending order
This topic is locked

Ascending order

 		4/29/2024 7:50:39 PM
PHPRunner General questions
D
 Dennis L author

If I have a field that has numeric numbers as well as numeric plus a letter how do I get it to put it in order like the filter option does? Currently is goes by the first number.
img alt
.
J
 		Jon_AK 5/17/2024

Use the ORDER BY field_name DESC; (or ASC if you want to go from highest to lowest) after the FROM clause in your SQL statement.