# \[php\]Setting display order for individual records?

**URL:** <https://forum.kirupa.com/t/php-setting-display-order-for-individual-records/167737>\
**Category:** programming\
**Created:** [October 31, 2005, 3:53pm UTC](https://forum.kirupa.com/t/php-setting-display-order-for-individual-records/167737 "2005-10-31T15:53:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![paul\_ferrie](https://avatars.discourse-cdn.com/v4/letter/p/919ad9/32.png) [@paul\_ferrie](https://forum.kirupa.com/u/paul_ferrie)\
**Post date:** [October 31, 2005, 3:53pm UTC](https://forum.kirupa.com/t/php-setting-display-order-for-individual-records/167737/1 "2005-10-31T15:53:22Z")

</div>

Hi guys,

Right ok lets see if i can get this out my head.

## DB setup

## mID = autoincrement ID mName= string info mImg = string info mOrder = number

Right ok so lets say i have 10 records  
so mOrder would be 1-10 for each record.

Right so some time down the line i might want to change the mOrder for record 8 to 1. So record 1 would need to have the mOrder updated to 2 and so on for each other record

How do i do this?

Thanks for any help suggestions