Solved

PHP Pagination by Letter

Posted on 2007-12-06
1
1,581 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
1 Comment
 
LVL 11

Accepted Solution

by:
Isisagate earned 500 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now