January 20th, 2013, 02:58 PM
Get last set of records without looping back to record 1
Hoepfully a quicky here!
I am working on a site, which requires a table to be screened, then every 10 records to be grabbed, and printed out to the screen.
However, it's the last 10 records I'm having problems with!
Basically I'm doing a simple LIMIT 0,10 - LIMIT 10,10 query and so on, but if I have a table that's 23 records populated, then on the 3rd repitition of the script (unfortunately at the moment it's 3 different querys, not being looped), we are printing the first 3 (rows 20,23), but also the next 7, from record 1 (1,7), I am totally confused, and would love some help, despite easy it might be!
January 20th, 2013, 04:49 PM
so am i
Originally Posted by josephman1988
LIMIT doesn't work that way, so you're doing something wrong/different
i'd love to critique your code and/or query, but i can't see it from here