Jquery sort table data

Question

I got struck in sorting tds in table using jquery.

My Demo fiddle

How can I call it for any table with id in my project?

var $sort = this; var $table = $('#mytable'); var $rows = $('tbody > tr',$table); $rows.sort(function(a, b) {     var keyA = $('td:eq(0)',a).text();     var keyB = $('td:eq(0)',b).text();     if($($sort).hasClass('asc')) {         return (keyA > keyB) ? 1 : 0;     } else {         return (keyA < keyB) ? 1 : 0;     } }); 

Answer 1

Something like this

function sortTable(table, order) {     var asc   = order === 'asc',         tbody = table.find('tbody');      tbody.find('tr').sort(function(a, b) {         if (asc) {             return $('td:first', a).text().localeCompare($('td:first', b).text());         } else {             return $('td:first', b).text().localeCompare($('td:first', a).text());         }     }).appendTo(tbody); } 

could be called on any table like this

sortTable($('#mytable'),'asc'); 

FIDDLE

Answer 2

I think you are missing the final "reset" function to sort the table. The desc code will not work because the order must be switched.

Code:

$('.sort').click(function (e) {     var $sort = this;     var $table = $('#mytable');     var $rows = $('tbody > tr', $table);     $rows.sort(function (a, b) {         var keyA = $('td', a).text();         var keyB = $('td', b).text();         if ($($sort).hasClass('asc')) {             return (keyA > keyB) ? 1 : 0;         } else {             return (keyA > keyB) ? 0 : 1;         }     });     $.each($rows, function (index, row) {         $table.append(row);     });     e.preventDefault(); }); 

Demo: http://jsfiddle.net/7wwvL/

UPDATE

More in general your function can be:

function sortTable($table,order){     var $rows = $('tbody > tr', $table);     $rows.sort(function (a, b) {         var keyA = $('td', a).text();         var keyB = $('td', b).text();         if (order=='asc') {             return (keyA > keyB) ? 1 : 0;         } else {             return (keyA > keyB) ? 0 : 1;         }     });     $.each($rows, function (index, row) {         $table.append(row);     }); }  sortTable($('#mytable'),'asc') 

Demo: http://jsfiddle.net/d7Kbx/