Enhancing an 'ORDER BY' clause to judge condition by more than 1 integer
- by Yvonne
Hi folks,
I have some PHP code which allows me to sort a column into ascending and descending order (upon click of a table row title), which is good. It works perfectly for my D.O.B colum (with date/time field type), but not for a quantity column.
For example, I have quantites of 10, 50, 100, 30 and another 100.
The order seems to be only…