# Update multiple records in MYSQL and PHP

**URL:** <https://forum.kirupa.com/t/update-multiple-records-in-mysql-and-php/198127>\
**Category:** Uncategorized\
**Created:** [August 22, 2006, 5:22pm UTC](https://forum.kirupa.com/t/update-multiple-records-in-mysql-and-php/198127 "2006-08-22T17:22:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![BlackBeltNinja](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/blackbeltninja/32/1180_2.png) [@BlackBeltNinja](https://forum.kirupa.com/u/BlackBeltNinja)\
**Post date:** [August 22, 2006, 5:22pm UTC](https://forum.kirupa.com/t/update-multiple-records-in-mysql-and-php/198127/1 "2006-08-22T17:22:33Z")

</div>

I have several items in a table of my database.  
they have numbers to identify their order, and the order system works great.

but if I delete one of these items that is in the middle of the order, then there is a gap in the order and gives me a few bugs.

basically I have this query that isnt totally functional

```auto
UPDATE list SET seq-- WHERE seq > '$delseq'

```

how would i pull off the seq–?  
I just need to subtract one from all of the seq values past the one I just deleted.