I am trying to fetch only the specific data from the db for a specific page. It works for the first load and shows the first 20 items. but then how can i add a function to the paging buttons to fetch the next page from the db
Sounds like you want server-side processing: http://datatables.net/release-datatables/examples/data_sources/server_side.html . Each draw (paging, sort etc) event will get the data for the draw from the server.
Replies
Allan