How To Use Jquery Datatable Plugin Properly

Below is my example code, but it's not working. Can someone please help me on how to use this jquery datatable plugin? And can this datatable plugin used on sql result field tabl

Solution 1:

From the docs: https://datatables.net/manual/installation

For DataTables to be able to enhance an HTML table, the table must be valid, well formatted HTML, with a header (thead) and a body (tbody). An optional footer (tfoot) can also be used.

Try adding a thead to your table with the correct number of columns.

It should look like this, but with however rows and columns you need, and your td's filled with your content.

<table>
    <thead>
        <tr>
            <th></th>
            <th></th>
            <th></th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td></td>
            <td></td>
            <td></td>
        </tr>
    </tbody>
<table>