Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jun 2007
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question View a number of records on eg. 10 of 100.

    Hi,

    I have a number of record in a database eg. 120 records.

    How do i allow the users to view the first 20 records... and underneath have like...

    [1] [2] [3] [4] ect. 20 on each page.

    Like what you see on the bootom off google when you search for something.

    Can any one help or point me in the right direction?

    Thanks.

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    The term you want to search for is pagination, there is a great deal of examples.
    http://www.google.com/search?hl=en&q...=Google+Search

    Good luck.

  • #3
    New Coder
    Join Date
    May 2007
    Location
    SF, CA
    Posts
    55
    Thanks
    0
    Thanked 4 Times in 4 Posts
    If you're using ASP then you will need to use something called recordset paging.

    Here's a pretty good article on it:

    http://www.codeproject.com/asp/rspaging.asp

    Other options include doing the paging entirely in javascript (sorry haven't ventured down that path).

    asp.net also makes paging much easier but I'm going to assume you're stuck with just plain asp.

    semper fi...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •