Browse Next Page Broken

[BoydG]

Having an issue with the Browse page.
When there's more than 1 page and I click the arrow to go to the 2nd page, it shows the same data as the first page.
I've figured out that any time a SQL browse query contains a where clause, this happens.

Suggestions?

[kev1n]

Hi,

I don't see this kind of issue with pagination here.

e.g. Browse SQL:

Code: Select all

SELECT * FROM mytable
WHERE table_field = 'something'

When I click the arrow to navigate to the 2nd page, different records are shown.

(using the latest from Sourceforge, Standalone version, not Wordpress Plugin)

[BoydG]

Thanks for the reply.
After further testing, I noticed I ended the SQL statement with a ;
When I took the semi-colon off, it started working.