PHP Custom Pagintion Help

Discussion in 'PHP' started by superlinksworld, Jun 28, 2012.

  1. #1
    Hi to all PHP Coder ,

    I have a large list of USA zipcode (80,000) . each page will contain 30 zipcodes like below

    11370 11371 11372 11373 11374
    11375 11376 11377 11378 11379
    11380 11381 11382 11383 11384
    11385 11386 11387 11388 11389
    11390 11391 11392 11393 11394
    11395 11396 11397 11398 11399

    Zip Code Database structure

    id - zipcode

    I want to build a pagination below

    11370 11371 11372 11373 11374
    11375 11376 11377 11378 11379
    11380 11381 11382 11383 11384
    11385 11386 11387 11388 11389
    11390 11391 11392 11393 11394
    11395 11396 11397 11398 11399

    Browse Zip code from [11400-11430] - [11431-11461] - [11462-11492] - [11493-11523] - [11524-11554] - [....]

    I want to sort out the zipcode and then display 30 zipcode per page and below the pagination for next 30 zipcodes 5 time and then simple [....] if user want to go further ..

    Can any one help ?

    Regards,

    D Najmi
     
    superlinksworld, Jun 28, 2012 IP
  2. NetStar

    NetStar Notable Member

    Messages:
    2,471
    Likes Received:
    541
    Best Answers:
    21
    Trophy Points:
    245
  3. liquidfire

    liquidfire Greenhorn Affiliate Manager

    Messages:
    68
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #3
    You could always use the mysql limit clause that's built in
     
    liquidfire, Jun 28, 2012 IP