Sorting Numeric Columns query

  • Resolved ibisman001

    (@ibisman001)


    9 years, 3 months ago

    I have installed your WP-DB-Table-Editor plugin and I am trying it out.
    I have a table that I can browse via phpMyAdmin. Lots of INT columns. I click on a INT column in the browser and sorting is fine.

    When I browse the table table via WP-DB-Table-Editor and try to sort a numeric column, the values are sorted alphabetically. e.g. 1, 10, 120, 2, 250, 3,40,5 …

    Any ideas how to make the sort in numerical sequence?

    Cheers,
    Peter

    https://www.ads-software.com/plugins/wp-db-table-editor/

Viewing 1 replies (of 1 total)
  • Plugin Author bobbysmith007

    (@bobbysmith007)

    Alright, there was some problem with the type detection, so I just replaced it with a system of trying to cast to number and if it works great. This seemed to resolve the bug. Thanks for your assistance in tracking down this matter.

    Please try out 1.5.3 to get this fixed on your end ??

    Cheers,
    Russ

Viewing 1 replies (of 1 total)
  • The topic ‘Sorting Numeric Columns query’ is closed to new replies.

Tags