Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Sorting high to low issue help

cruser 15 Oct, 2020

In the screenshot below you can see that there columns "Item 1" and "Item 2" have values. Item 2 column does not sort in the proper order as the value 53 is less than 520. How do I get this so that single, double, and triple-digit values sort properly? Item 1 column sorts highest to lowest while Item 2 sorts the results of Item 1 from highest to lowest.

Max_admin 23 Oct, 2020

Answer

maybe this page can give you some help on sorting in mysql:
https://stackoverflow.com/questions/8557172/mysql-order-by-sorting-alphanumeric-correctly

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

cruser 23 Oct, 2020

1 Likes

Hey thanks, Max! I changed the structure type in those columns from varchar(255) to int(255) and it all lined up perfectly.

You need to login to be able to post a reply.