Search

intval( $_GET['iDisplayStart'] ).", ". intval( $_GET['iDisplayLength'] ); } /* * Ordering */ $sOrder = ""; if ( isset( $_GET['iSortCol_0'] ) ) { $sOrder = "ORDER BY "; for ( $i=0 ; $i<intval(

SQL you'd simply do ORDER BY {col1} ASC, {col2}

sLimit = "LIMIT ".$_GET['iDisplayStart'] .", ". $_GET['iDisplayLength'] ; } /* * Ordering */ if ( isset( $_GET['iSortCol_0'] ) ) { $sOrder = "ORDER BY "; for ( $i=0 ; $i<intval(

must specify sDefaultContent in order for DataTables to know

in the same index order as the internal cache,

WHERE OR #thisColumn# LIKE ORDER BY , #listGetAt(listColumns,(url["iSortCol_"&thisS]+1))# #url["sSortDir_"&thisS]# SELECT

Math.ceil( oSettings._iDisplayStart / oSettings._iDisplayLength ); var order = new Array(); $(this).parents('table').find('tr').each(function() { if

previously. The actual column order in the table has

TOP 10000 * FROM Activity ORDER BY id DESC"; using

configure sort type and order with html5 data attributes