[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1601
  • Last Modified:

PHP Pagination by Letter

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
seopti
Asked:
seopti
1 Solution
 
IsisagateCommented:
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now