Thread: Paging in mysql

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    mumbai,maharashtra,india
    Posts
    2
    Rep Power
    0
    how do u do paging using ASP & mysql
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    what do you mean by paging?

    why use asp?

    ---John Holmes...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    mumbai,maharashtra,india
    Posts
    2
    Rep Power
    0
    paging means displaying records in break system .like it is done when u search something like next page & page nos are shown

    & i have an assignment that i have to do in Active server pages only
    so reply back if u know about it

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by SepodatiCreations:
    what do you mean by paging?

    why use asp?

    ---John Holmes...
    [/quote]



    ------------------
    catch me at
    beedeep@rediffmail.com
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Fredericton, NB, Canada
    Posts
    3
    Rep Power
    0
    To page using mySQL you have to use the LIMIT command like this

    SELECT fields ...
    FROM table
    LIMIT $offset,$pgsize

    store the page number you are on in your html form as a hidden field or a cookie or whatever you're comfortable with so that you can pass it back to your ASP or CGI in order to figure out the next $offset (i.e. $offset = ($pg-1) * $pgsize)

    Hope this helps

    Dan

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. mysql and MS foxpro
    By wijbenga in forum MySQL Help
    Replies: 16
    Last Post: February 5th, 2004, 12:46 PM
  3. Hebrew Charset, MySQL, PHP, Searching
    By ezuk in forum MySQL Help
    Replies: 0
    Last Post: September 4th, 2003, 02:12 AM
  4. mysql connection
    By cindyqz in forum Java Help
    Replies: 0
    Last Post: August 25th, 2003, 08:33 PM
  5. Getting Access to use MySQL
    By -=-steve-=- in forum MySQL Help
    Replies: 1
    Last Post: November 11th, 2001, 12:01 PM

IMN logo majestic logo threadwatch logo seochat tools logo