I’m having a bit of trouble with pagination. I’ve got a query like this.
SELECT `username`, `body`, `threadToken`, `token` FROM `thread_replies_36933753` WHERE `threadToken` = :threadToken LIMIT :limit, :offset
From reading articles LIMIT is the first number, and offset is the second.
I keep getting empty results. I only get results with values 0,[number]
Does this mean that I need to switch the place of limit and offset? I know it’s a dumb question, just don’t understand why w3schools says the order is the other way.