my sql limit

 SELECT * FROM `your_table` LIMIT 0, 10 

This will display the first 10 results from the database.

 SELECT * FROM `your_table` LIMIT 5, 5 

This will show records 6, 7, 8, 9, and 10