Pagination in Php

[jessy]

i want to display the results of a sql statement in several pages
i have 6 rows .and i set the page limit to 2 rows
so i have 3 pages
i followed some tutorial online :

http://php.about.com/od/phpwithmysql/ss/php_pagination_3.htm

but when i click next i have no results to display !!
the while loop just selects the 1st 2 rows only ???
[CODE DELETED]

[RedSon]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[ak1dnar]

Hi Jessy,
This is your 36th post to our forum. We are happy to help you. but please just follow the posting guidelines again. Post your codes with relevant tags. thanks.