is there a bug in datatables.net/examples/server_side/server_side.html

london59

It appears to me that the query that determines the filter set size should not use the query:

$sQuery = "
SELECT *
FROM $sTable
$sWhere
$sOrder
$sLimit
";

but should rather use my version:

$PSSsQuery = "
SELECT *
FROM $sTable
$sWhere
$sOrder
";

any thoughts?

Paul

allan

No there isn't. There are three queries:

1. Get the data for the current page
2. Get the number of records that are in the filtered set
3. Get the total number of records.

The current code performs those actions. I'm quite prepared to be proven wrong, but it looks right to me.

Allan