Displaying a LIMIT of 10 records

Anon

Hello,

I built and manage KillerSurfLinks.com Basically it's a search engine for the Ocean Surfing Community. It's growing
pretty good now and I have the need to display only 10 records at a time from my record set.

I would also like to display a message like this "Showing records 0 - 30 (244 total)" on the top of each page of the
returned query.

And a "Next or Prev" Hyperlink to the next group in my record set or back to the previous group of records in the
records set on the bottom of the page.

I can probably work through it but I was wondering if anyone knew where there was a snipet of code that can I can
get that will get me started?

Thanks,
Mike

afortaleza

Hello Mike...

...there is a discussion in this topic in a article here in PHPBuilder called "Building Next/Prev Buttons" at http://www.phpbuilder.com/columns/rod20000221.php3

If I'm not wrong, I think that the code has some mistakes or something, but there is a good discussion in the Annotate System down the article. It's good to read and to learn with it. Not hard task, just use the LIMIT switch in your SQL query. Take some time to read the article.

Anderson Fortaleza

Anon

Anderson Fortaleza,

Thank you very much for pointing me into a
direction I can learn about it.

Mike