Solved

PHP Pagination by Letter

Posted on 2007-12-06
1
1,582 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
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…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

910 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

23 Experts available now in Live!

Get 1:1 Help Now