Number of records not matching iDisplayLength of 10

ctseng7

Hi,

I have a simple PHP program that use server-side processing to get mysql database and the total records is 29, I set the iDisplayLength=10 in the initialization but the table display all 29 records, the bottom message said "Showing 1 to 10 of 29 entries" with 3 buttons. What might have caused the problem?

The server-side data has {"sEcho":1,"iTotalRecords":"29","iTotalDisplayRecords":"29","aaData":[[...]]} and I wonder if this iTotalDisplayRecords has to be 10 in order to display 10 on the table?

Thanks

ctseng7

I found the problem in mysql that I accidentally commented out the sLIMIT part of codes, after correcting this problem page is display 10 records per page.