[jQuery] tablesorter.js vs Numerals with Commas
<div><div><div>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:</div>
<div></div><div>2</div><div>18</div><div>401</div><div>3</div><div>15</div><div></div><div>But this column...</div><div></div><div>1,200</div><div>408</div><div>26,048</div><div></div><div>...would sort like this:</div><div>
</div><div>1,200</div><div>26,048</div><div>408</div><div></div><div>Does anyone know how to fix this?</div><div></div><div>I'm using PHP and MySQL to derive my data from a database table, using the following code:</div>
<div></div><div>$Area = number_format($row["Area"]);</div><div></div><div>Then I simply insert $Area in a dynamic table cell, like so...</div><div></div><div><td>$Area</td></div><div></div><div>I posted my JavaScript links below. Thanks for any tips!</div>
<div></div><div>* * * * *</div><div></div><div><script src="<a href="http://MySite/js/jquery-1.3.1.min.js">http://MySite/js/jquery-1.3.1.min.js</a>" type="text/javascript"></script>
<script src="<a href="http://MySite/js/tablesorter/jquery.tablesorter.js">http://MySite/js/tablesorter/jquery.tablesorter.js</a>" 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>
</div><div>
</div></div><div>--
</div></div>
<div>David Blomstrom
Writer & Web Designer (Mac, M$ & Linux)
<a href="http://www.geobop.org">www.geobop.org</a>
</div>