how can i divide the records in pages by using mySQL?

[Tommy-girl]

how can i divide the records in pages by using mySQL?
for examble , when i made a query it gave me 80 records i wanna to divide it in 3 pages .

what can i do??

[barand]

You need to use the LIMIT clause in your SELECT statement. Limit uses an offset and number of records, so

SELECT * FROM table LIMIT 0,30     /*first 30 recs*/
SELECT * FROM table LIMIT 30,30   /*next 30 recs*/
SELECT * FROM table LIMIT 60,30   /*next 30 recs*/

[tomhath]

http://www.phpbuilder.com/columns/rod20001214.php3