I've just updated my sortable table script to version 1.5, in which it is fixed to work in Safari for Mac OS X 10.4 as well, (I didn't even know that it wasn't working in there since it always worked in the nightly). I'm now taking new feature requests for this script, so hit me with them, in the comments or by e-mail.
Yoast tweaking websites
Follow Yoast on Twitter, or subscribe to this blog by email or RSS!
Sortable table v1.5
Liked this post?
Subscribe to the RSS feed or to weekly email updates, right now!
You can skip to the end and leave a response.
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).
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 :)
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.
Hmm cool, do you have some table where i can test this? :)
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
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.
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 ?
Sorry ...
echo "" -> td and tr ... /td and /tr
I have changed my phpscript but don't work...
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!
Shane: if you turn around date and time, it might work...