Page 1 of 1

PHP Pagging

Posted: Sun Nov 27, 2011 8:55 pm
by saren
Dear all, I have list of record that is too long (100 records) and I want to separate it in 10 records per page. can some give me code of pagging in PHP with MySQL with detail of common line.
Thanks

Re: PHP Pagging

Posted: Sun Nov 27, 2011 9:14 pm
by Celauran
Add a LIMIT clause to your query, say, LIMIT $offset, 10. Use $_GET['page'] to determine the value of $offset.

Re: PHP Pagging

Posted: Mon Nov 28, 2011 4:33 am
by maxx99