Sorry for the late response; I posted three questions regardingthe tablesorter/zebra stripes functions, but I thought they hadn't been posted on this forum. Anyway, thanks for the tip, but the first one didn't work for me, and I can't figure out how to implement the second. Can you show me how to insert the code within my code? Thanks. echo '<script src="'.$BaseURL.'/1A/js/jquery-1.3.1.min.js" type="text/javascript"></script> <script src="'.$BaseURL.'/1A/js/tablesorter/jquery.tablesorter.js" type="text/javascript"></script> <script language="JavaScript" type="text/JavaScript"> $(document).ready(function() { $("#myTable").tablesorter({ widgets: [\'zebra\']} );
$("#triggerMS").click(function(){ $("#menuMS").show(); return false; }); $("#menuMS").click( function(){ $("#menuMS").hide(); return true; }); $("#triggerReg").click(function(){ $("#menuReg").show(); return false; }); $("#menuReg").click( function(){ $("#menuReg").hide(); return true; }); $("#triggerKids").click(function(){ $("#menuKids").show(); return false; }); $("#menuKids").click( function(){ $("#menuKids").hide(); return true; }); $("#triggerLinks").click(function(){ $("#menuLinks").show(); return false; }); $("#menuLinks").click( function(){ $("#menuLinks").hide(); return true; }); $("#triggerBooks").click(function(){ $("#menuBooks").show(); return false; }); $("#menuBooks").click( function(){ $("#menuBooks").hide(); return true; }); } ); </script>'; On Thu, Apr 30, 2009 at 1:54 PM, aquaone <aqua...@gmail.com> wrote: > There are two simple ways of fixing this: having a hidden span or similar > element appearing within your td prior to the value or better to define your > own parser. > > e.g. > $.tablesorter.addParser({ > id: "commaNum", > is: function(s) { > return /^[\d-]?[\d,]*(\.\d+)?$/.test(s); > }, > format: function(s) { > return s.replace(/,/g,''); > }, > type: 'numeric' > }); > > aquaone > (yes, you could use a more precise regex...) > > > On Wed, Apr 29, 2009 at 20:41, David Blomstrom > <david.blomst...@gmail.com>wrote: > >> I'm using jQuery's tablesorter.js to create tables with sortable rows. It >> works fine on both text and numerals - but only if they have no commas. For >> example, the following column would sort properly: >> 2 >> 18 >> 401 >> 3 >> 15 >> But this column... >> 1,200 >> 408 >> 26,048 >> ...would sort like this: >> 1,200 >> 26,048 >> 408 >> Does anyone know how to fix this? >> I'm using PHP and MySQL to derive my data from a database table, using the >> following code: >> $Area = number_format($row["Area"]); >> Then I simply insert $Area in a dynamic table cell, like so... >> <td>$Area</td> >> I posted my JavaScript links below. Thanks for any tips! >> * * * * * >> <script src="http://MySite/js/jquery-1.3.1.min.js" >> type="text/javascript"></script> >> <script src="http://MySite/js/tablesorter/jquery.tablesorter.js" >> type="text/javascript"></script> >> <script language="JavaScript" type="text/JavaScript"> >> $(document).ready(function() >> { >> $("#myTable").tablesorter({ widgets: ['zebra']} ); >> >> $("#triggerMS").click(function(){ >> $("#menuMS").show(); >> return false; >> }); >> $("#menuMS").click( function(){ >> $("#menuMS").hide(); >> return true; >> }); >> >> $("#triggerReg").click(function(){ >> $("#menuReg").show(); >> return false; >> }); >> $("#menuReg").click( function(){ >> $("#menuReg").hide(); >> return true; >> }); >> >> $("#triggerKids").click(function(){ >> $("#menuKids").show(); >> return false; >> }); >> $("#menuKids").click( function(){ >> $("#menuKids").hide(); >> return true; >> }); >> >> $("#triggerLinks").click(function(){ >> $("#menuLinks").show(); >> return false; >> }); >> $("#menuLinks").click( function(){ >> $("#menuLinks").hide(); >> return true; >> }); >> >> $("#triggerBooks").click(function(){ >> $("#menuBooks").show(); >> return false; >> }); >> $("#menuBooks").click( function(){ >> $("#menuBooks").hide(); >> return true; >> }); >> >> } >> ); >> </script> >> >> -- >> David Blomstrom >> Writer & Web Designer (Mac, M$ & Linux) >> www.geobop.org >> > > -- David Blomstrom Writer & Web Designer (Mac, M$ & Linux) www.geobop.org