dexter666

Hi,

had the same problem, trying to sort the output.
Found a simple solution without changing the php.ini.
It’s also possible to change the output for each single table.

Just go to the bottom of your ultimate table:

"oLanguage": {
		"sLengthMenu": "Display _MENU_ records per page",
		"sZeroRecords": "Nothing found - sorry",
		"sInfo": "Showing _START_ to _END_ of _TOTAL_ records",
		"sInfoEmpty": "Showing 0 to 0 of 0 records",
        	"sSearch": "Search: ",
		"sInfoFiltered": "(filtered from _MAX_ total records)"
	}

and add following in a new line at the end (for a table with 5 columns):

"aaSorting": [[ 5, "desc" ]]

will look like this:

"oLanguage": {
		"sLengthMenu": "Display _MENU_ records per page",
		"sZeroRecords": "Nothing found - sorry",
		"sInfo": "Showing _START_ to _END_ of _TOTAL_ records",
		"sInfoEmpty": "Showing 0 to 0 of 0 records",
        	"sSearch": "Search: ",
		"sInfoFiltered": "(filtered from _MAX_ total records)"
	},

"aaSorting": [[ 5, "desc" ]]