# Reorder database rows

**URL:** <https://forum.kirupa.com/t/reorder-database-rows/293010>\
**Category:** programming\
**Created:** [July 22, 2009, 2:28am UTC](https://forum.kirupa.com/t/reorder-database-rows/293010 "2009-07-22T02:28:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![drummer392](https://avatars.discourse-cdn.com/v4/letter/d/45deac/32.png) [@drummer392](https://forum.kirupa.com/u/drummer392)\
**Post date:** [July 22, 2009, 2:28am UTC](https://forum.kirupa.com/t/reorder-database-rows/293010/1 "2009-07-22T02:28:33Z")

</div>

I am wanting for the user to be able to reorder the pages in the CMS. I have table called ‘pages’ with values ‘id’, ‘title’, and ‘maintext’. What is the best way to do this? It would be ideal to just have a button with an arrow that when clicked switches the id of the row above it.

Thanks!