Search

doing that sorting in table is not working. Please

the dropdown, but the table is not filtered. Any

my code for data table is $(document).ready(function(){ var t

WHERE condition to the table for that admission ID.

DataTables has redrawn the table' ); } }); $('#mytable').on( 'draw.dt', function () { console.log(

you are initializing the table every click, you have

clear() to clear the table and then rows.add() to

If you want to show different columns, and otherwise use different initialisation options, you would need to destroy the table (destroy()) and then create a new DataTable. Allan

Setting $table to an SQL query.... Why would you do that? The $table variable obviously requires a table name.

I figured it out. Modifying the success function of the ajax calls as follows worked: success: function(response) { $('#results').html('<table id="table-output" class="display" cellspacing="0" width="100%"></table>'); table_config.columns = response.columns; var table = $('#table-output').DataTable(table_config); table.clear(); table.rows.add(response.data); table.draw(); }