Search

mean: MySQL [PLAYGROUND]> show columns from JSON_TEST; +------------+------+------+-----+---------+-------+ | Field | Type

by ? Even for the columns with the buttons "Modify"

fetch_data(); function fetch_data(){ $(document).ready(function() { $('#customer_table').DataTable({ "processing" : true, "serverside" : true, "ajax" : { url: "connect.php", type: "POST", data: {action: 'fetch'}, error: function(xhr, error, thrown) { console.log("AJAX error:", error, thrown); }, }, "columns": [ { data: 'FIRSTNAME' }, { data: 'LASTNAME' }, { data: 'NIC' } ], }); }); } please help

2 up in the columns array that is also

can add just the columns you want using the column-selector, for example: table.columns( [0,1,2]

or maybe two specific columns like you show here,

select: true, responsive: true, columns: [ { title: "Input log history",

that data. Add those columns using option columns.data and

dataSrc : "data" }, dom: 'Bfrtip', columns : [ {data : 'COMPANY_NAME'} ,{data : 'ABN'}

I fixed the issue by installing the jquery types, butt still can't use the fixed columns and other attributes