pagination

Discussion in 'PHP' started by es-es, Jun 24, 2012.

0
  1. #1
    i'have created a pagination in phpmyadmin using tables.But i dont know how to import my webpages into table values, do you know how can i do that?
     
    es-es, Jun 24, 2012 IP
  2. DevSwift

    DevSwift Peon

    Messages:
    103
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    0
    #2
    You created 'pagination in your database'? That makes no sense. Generally, when paginating large responses from MySQL, you paginate from the PHP end just by modifying the MySQL queries... so this is an example of queries per page, displaying 10 results per page:

    Page 1: SELECT FROM `table` WHERE `column` = 'value' LIMIT 0,10
    Page 2: SELECT FROM `table` WHERE `column` = 'value' LIMIT 10,10
    Page 3: SELECT FROM `table` WHERE `column` = 'value' LIMIT 20,10
     
    DevSwift, Jun 25, 2012 IP
  3. Irfi0009

    Irfi0009 Banned

    Messages:
    17,584
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    48
    #3
    dear same my friend devswift
     
    Irfi0009, Jun 25, 2012 IP