# Mysql/php next page with an ORDER BY

**URL:** <https://forum.kirupa.com/t/mysql-php-next-page-with-an-order-by/46495>\
**Category:** Uncategorized\
**Created:** [March 25, 2004, 3:07am UTC](https://forum.kirupa.com/t/mysql-php-next-page-with-an-order-by/46495 "2004-03-25T03:07:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kill\_robot\_kill](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/kill_robot_kill/32/359_2.png) [@kill\_robot\_kill](https://forum.kirupa.com/u/kill_robot_kill)\
**Post date:** [March 25, 2004, 3:07am UTC](https://forum.kirupa.com/t/mysql-php-next-page-with-an-order-by/46495/1 "2004-03-25T03:07:35Z")

</div>

I have a list of links that are sorted alphabetically by MySQL, then put into a php page. is there any way, in php (or mysql) to be able to create a link that would go from the first returned row alphabetically to the next one.  
So say I have something like this:  
ID---------------FRUIT  
3----------------APPLE  
2----------------BANANA  
5----------------CHERRY  
1----------------GRAPE  
4----------------ORANGE

how could I create it so I could go from apple to banana to cherry to grape to orange.