view next results from select stmt.

[Anon]

I used the LIMIT feature in my select statement to select 25 records at a time. How can I view the next 25??

Thanks for your time and help!

[cordex]

SELECT * FROM TABLE LIMIT $i, 25
where $i is the starting location (previous limit plus previous location)
should do it for you.