indexing columns via serverside-php-mysql
indexing columns via serverside-php-mysql
Hello, I'm trying to use counting rows in datatables but.. in .php file i have
/* Array of database columns which should be read and sent back to DataTables. Use a space where you want to insert a non-database field (for example a counter or static image) */
$aColumns = array('name','game','game1','game2','game3','game4','max');
and js:
jQuery(document).ready(function() {
var t = jQuery('#newTable').DataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "/wp-content/themes/streamerzy/datatable_ranking_main.php",
"order": [[ 3, "desc" ]],
"columnDefs": [ {
"searchable": false,
"orderable": false,
"targets": 0
} ],
} );
t.on( 'order.dt search.dt', function () {
t.column(0, {search:'applied', order:'applied'}).nodes().each( function (cell, i) {
cell.innerHTML = i+1;
} );
} ).draw();
} )
but all time i have error "DataTables warning: table id=newTable - Requested unkown parameter '7' for row 0, column 7. For more info.. datatables.net/tn/4"
what im doing wrong?
Answers
Can anyone answer? i think there is a bug..