Search

object we might use: columns: [ { data: "users.first_name" }, { data: "permission",

url: "/api/join", type: 'POST' }, columns: [ { data: "users.first_name" }, { data: "users.last_name"

obtain data from SQL columns, as shown above, it

is done using the columns.render option, used as a

constrained to rows and columns like a table, but

adjust the number of columns in the table (columns)

new DataTable('#myTable', { ajax: '/api/staff', columns: [ { data: 'first_name' }, { data: 'last_name'

dom: "Bfrtip", ajax: "php/users.php", columns: [ { data: "first_name" }, { data: "last_name"

When ordering columns by clicking on their

Using sName to order columns with server-side processing or

Debugging the code you can see the Age and Salary columns are string data not numeric. You can convert them to numbers. See this example for debug output and the conversion to numbers: http://live.datatables.net/xogecoju/1/edit Kevin

the headers to the columns, if they're not, you'll

a bunch of sliding columns. I'm using KeyTable to

same priority for all columns (because I want users

users ability to order columns. As stated in the

for the number of columns. Do you get an

url: 'ajaxGetAll.php', type: 'POST', }, columns: [ {data: "userId", title: lang().users.thId},

autogenerated widths of needed columns with fixed width and

However I forced the columns to be trated as

a colspan across all columns.. The format function in