Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

PHP Pagination by Letter

Posted on 2007-12-06
1
Medium Priority
?
1,596 Views
Last Modified: 2008-02-01
Hello!

please see the pagination snippet. It works fine and shows the pagination for all cities within a certain state.

This is a numeric pagination:

0 25  50 75 100 ....

How do I need to change the code to make an alphabetical pagination like this:

Ab - Bc    Bd-Ca    Db - Gi ...

Thanks for help.





<?php
$totalToDo = $numRecords / 25;
 
 
while ($counter < $totalToDo) {
    $pageNumber = $counter * 25;
        if($pageNumber == 0)
        {
        echo '<a href="'. $urlPrefix . $sectionNameLink . '-apstate.html"><b>' . $pageNumber . '</b></a> | ';
        }
        else
        {
        echo '<a href="'. $urlPrefix . $sectionNameLink . '-apstate-' . $pageNumber . '.html"><b>' . $pageNumber . '</b></a> | ';
        }
$counter = $counter + 1;
}
?>
 
...
 
$result = mysql_query("SELECT DISTINCT bizCity FROM biz_aaa WHERE bizState='$bizState' AND bizLive='1' ORDER BY bizCity ASC LIMIT $offset,25");

Open in new window

0
Comment
Question by:seopti
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
Isisagate earned 1000 total points
ID: 20423205
This should help get you started. You will want to run a query that only returns the results for the set of letters and pass in the letter sets. Then output the returned results...

$letterStart = "Ab";
$letterEnd = "Bc";

$result = mysql_query("SELECT DISTINCT bizCity FROM biz_aaa WHERE bizState='$bizState' AND bizLive='1' and bizCity between  '$letterStart'  and '$letterEnd' ORDER BY bizCity ASC");


0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question