August 30th, 2000, 11:46 PM
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.?
August 31st, 2000, 02:04 AM
display in what (web browser?), using what language (php?)
September 1st, 2000, 04:49 AM
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 .
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