pagination with alphabetical links

[pixeltrace]

hi,

 

is there any pagination php script available online

which also has an alphabetical buttons?

 

thanks!

[Psycho]

---

Just take the script from this tutorial: http://www.phpfreaks.com/tutorials/43/0.php and modify for your particular data and tables.

 

Then change this

    if(empty($page)){ 
        $page = 1; 
    } 

 

to this

    if (isset($_GET

---

)) {

      if (is_numeric($_GET

---

)) {
        $page = $_GET

---

;
      } else {
        $query  = "SELECT count(*) FROM table WHERE field >= '".substr($_GET[letter], 0, 1)."'";
        $result = mysql_query($query);
        $page   = ceil((mysql_num_rows($result) / $limit));
      }

    } else {

      $page = 1;

    }

 

If all is working you should be able to create a link to go to the first page of a particular letter using a link like so:

 

echo "<a href=\"$_SERVER['PHP_SELF']&page=a\">A</a> ");