Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Pagination recommendations

    I am a PHP programmer for a small startup. We are storing person records and our MS SQL Server 2000 database has grown to the point where we wish to paginate the data before returning it to my PHP scripts.

    I was wondering if anyone has any recommendations on an optimal way to manage this given the following requirements.

    - Data must return only X number of rows at a time (user configurable).
    - Must be able to search by several diffent criteria (name, date, birthday, location, ...)

    Also, I was wondering if it is possible to return the total number of existant rows of data as the first row of a MSSQL procedure.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Pagination recommendations

    Originally posted by shauns
    Also, I was wondering if it is possible to return the total number of existant rows of data as the first row of a MSSQL procedure.
    What does that mean?

    Did you do a search of this site? Either here or sql team (or both) I know we've bantered this one about a couple of times...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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