Thread: MySQL problem
View Single Post
Old 05-05-2002, 02:43 PM  
boldy
Macdaddy coder
 
Industry Role:
Join Date: Feb 2002
Location: MacDaddy pimp coder
Posts: 2,806
Just end your query with

LIMIT 10, 1
will return the 11th record

LIMIT 10, -1
will return the 11th record through end of table

Cheers!
__________________
MacDaddy Coder.
boldy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote