Google like pagination

[Anon]

Hi
i want to do google like pagination in php.can anybody help me where i can find a similar code.
my code is not working
Thanks in advance
Beenish

[techek]

What do you mean by "pagination" like Google? What data do you want to display, where do they come from and such?

/Techek

[Anon]

I wrote a class which displays 1 2 3 4 5 link pages. Is it what you want? Just email me at [e-mail]

The class takes a mysql query, finds the number of results, than returns all what you need: current page, total number of pages, total number of pages to show, etc.

The class is not perfect, because there is some html code returned by some functions, but still I guess it will be a good starting point for you.

[yurko]

recently i wrote a guestbook with 'pagination'.
Some tips:
1) sql:
"SLECT field1,..fieldN
FROM your_table
LIMIT start_row_number, your_nuber_of_rows_on_the_page";

2) You must calculate start_row basing on page you are going to display and number of rows on the page.

3) To know how many pages there are I use this:
"SELECT count(*) FROM your_table"

If somebody knows better way I will like to know.

[eojlin]

I just uploaded a snippet, "DbHtmlTable," in the "Code Library" section of this website. Under Database category.

I have there a pagination that scrolls to the nearest 10 pages around the current page.