Search

id, nom_categorie FROM categories ORDER BY nom_categorie"; $query = $this->db->prepare($sql);

There isn't an ajax.order option in DataTables. Nor actually is there an ajax.columns option. They should both be at the top level - see order and columns. Allan

table.find("thead").on('click', 'th', function () { table.api().rows({ order: 'applied' }).data(); excelJsonData = table.fnGetData();

draw them out of order due to the draw

datatable with row re order, but when its rendered

this ); } ); $('#main_table').DataTable ( { "dom": "Bfrtip", "order": [[ 1, "desc" ]], "ajax": { "url":

I see - thanks. You could use something like: var deep = $.fn.dataTable.ext.deepLink( [ 'search.search', 'order', 'displayStart' ] ); $('#myTable').DataTable( { $.extend( { autoWidth: false, ... }, deep ); } ); Allan

the search() docs: In order to have the search

DataTable with pagination in order to split the information

English data in alphabetical order, followed by foreign characters