Search

following selector: $('>td',nRow) in order to have only the

refreshed in the same order as it was in

the Jeditable website, in order to set it in

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

Resolved... I change the form of the datatable was rendering and then corrected the column order.

loaded and in what order. The only thing DataTables

of putting it. [code] /* * Ordering */ if ( isset( $_GET['iSortCol_0'] ) ) { $sOrder = "ORDER BY "; for ( $i=0 ; $i<intval(

the table - thus in order to avoid a confusing

In order by avoid alert box, with some help by other users, i've posted here a possible solution: http://datatables.net/forums/discussion/4642/hide-alerts-from-datatable#Item_7

Ah yes, echo, ahem. I get SELECT SQL_CALC_FOUND_ROWS library_fact.id, library_fact.fact_code, library_fund.name, library_fact.createdby, library_fact.published, library_fact.editedby, library_fact.modified FROM library_fact, library_fund ORDER BY library_fact.editedby desc LIMIT 0, 10 {"sEcho":1,"iTotalRecords":"130","iTotalDisplayRecords":"17688","aaData":[[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null],[null,null,null,null,null,null,null]]}