how can i distinct the pages number in ssp.class.php

jaldea

I used the DISTICT in main query

// Main query to actually get the data
$data = self::sql_exec( $db, $bindings,
"SELECT DISTINCT ".implode(", ", self::pluck($columns, 'db'))."
FROM $table
$where
$order
$limit"
);

example:

i set the page to 5 rows per page
and
i have 10 rows in my dbase.
after i used the distinct it only shows 6 rows in the datatable which is correct.

but in the paging, when im going to the last page it is still showing like this:

Showing 6 to 10 of 10 entries

but it must be like this:

Showing 6 to 6 of 6 entries

because the last page only display only 1 rows.

is there a way in this problem? please help

jaldea

hi, i have fixed my problem thank you anyway