MySQL supports the LIMIT
keyword, which allows you to control
how many rows are returned; ideal when displaying data over many pages. You can
use LIMIT
in your sql query like this:
SELECT name FROM table LIMIT 10
if you want to get the rows between 10 and 20 do the following:
SELECT name FROM table LIMIT 9, 10
For a ADO solution (with an Access / MS SQL Server database), click here.
Comments