how can we limit the recored displayed

[aayatoos]

how can we limit the recored displayed on a page in for example 10 recored and the reset display it in anther page

[pyro]

Use LIMIT, like this:

SELECT * FROM tablename LIMIT 10

which will return the first 10 records, or:

SELECT * FROM tablename LIMIT 10, 10

which will return the second 10 (or more specifically, 10 records, starting with the 10th)