restricting the # records

in my data base there are thousands of records are there, i want to retrieve them and display only 15 records at a time.how can it possible.?

------------------

display in what (web browser?), using what language (php?)

Regardless of the language you use , if you sending a query in mysql and are trying to limit the no. of retreived records you can use "limit" at the end of the select statement to restrict the records also u can use the where option generally for this purpose .
eg
SELECT * FROM table_name LIMIT 10,10;
will give you all the columns of table "table_name" and total 10 rows starting from the tenth row