10 Responses to Sortable table v1.5

  1. Joost de Valk

    Shane: if you turn around date and time, it might work…

  2. Shane
    Shane  • 11 years ago

    I love this script! It’s been a lifesaver.

    I’ve got a column with time and date ( 8:45pm 05/03/07) and it makes a mess of sorting. Any suggestions?

    My first thought was to hack together some way to sort by a hidden value, perhaps sort by td id. Then I could make the id the unix timestamp and it would always sort correctly.

    Thanks again for a fantastic script!

  3. The Bebos
    The Bebos  • 11 years ago

    Sorry …

    echo “” -> td and tr … /td and /tr

    I have changed my phpscript but don’t work…

  4. The Bebos
    The Bebos  • 11 years ago

    Very Nice… Wonderful

    But .. with an integration like mysql …. for example..

    while ($mr=mysql_fetch_array($data)){
    echo “”.$mr[“field1″].””;
    echo “”.$mr[“field2″].””;
    echo “”.$mr[“field3″].””;
    }

    is possible ?

  5. František Malina
    FrantiÅ¡ek Malina  • 11 years ago

    I forgot, click any car to see its review.

    I also used it to sort items in a shopping cart, used car reviews, product listings. I tried lot of scripts to do this, but your JS is out of the box goodness.

  6. František Malina
    FrantiÅ¡ek Malina  • 11 years ago

    Thank you for your plug and play script, I love it.

    Please, do not spend your time with any new features. It is perfect AS IT IS. I now use it with near any table where applicable. It ads boring data good user expereince without any server side scripting.

    See it in action on
    http://www.rrg-group.com/ucl/ucl_Home.asp

  7. Joost de Valk

    Hmm cool, do you have some table where i can test this? :)

  8. João Costa
    João Costa  • 12 years ago

    The first is actually quite simple to implement, since Javascript can cope with the scientific numeric format. For instance, you can just change line 110 from:

    if (itm.match(/^[\d\.,\-]+$/)) sortfn = ts_sort_numeric;

    to:

    if (itm.match(/^[\d\.,\-]+(E[-+][\d]+)?$/)) sortfn = ts_sort_numeric;

    The regular expression can probably be optimized, but this one works on Firefox 1.5 and IE 6 in Windows.

  9. Joost de Valk

    Hey João, thx for the great ideas, the first would be hard i think, the second sounds like a lot of work but doable indeed :)

  10. João Costa
    João Costa  • 12 years ago

    Nice script you have here. Let me suggest some possible improvements:

    – Correctly sort numbers such as: 9.9999997E-20, 1.0000000E-10 and 9.9999997E-06 or 1.0997E+06.

    – Allow show/hide of individual columns, and store in a cookie which columns are visible for next time same page is opened (a bit tricky, but doable).


Check out our must read articles about Analytics