# \[help\] moving values in a table

**URL:** <https://forum.kirupa.com/t/help-moving-values-in-a-table/247340>\
**Category:** programming\
**Created:** [December 21, 2007, 1:14pm UTC](https://forum.kirupa.com/t/help-moving-values-in-a-table/247340 "2007-12-21T13:14:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cjj](https://avatars.discourse-cdn.com/v4/letter/c/ecc23a/32.png) [@cjj](https://forum.kirupa.com/u/cjj)\
**Post date:** [December 21, 2007, 1:14pm UTC](https://forum.kirupa.com/t/help-moving-values-in-a-table/247340/1 "2007-12-21T13:14:00Z")

</div>

I have a problem and I’m not sure how to solve it. I hope this isn’t too confusing. I have already confused myself. Ha, ha. 😃

Ok, so I have a table with columns called _‘pic\_1’, ‘pic\_2’, ‘pic\_3’, ‘pic\_4’_ and so on till about \*‘pic\_40’.

\*I have already created a script which places the correct info into the correct column. But the problem I have now is that I need to create a script where you can delete specific pictures from that table.

So basically someone can choose from a list and say they wanna delete \*‘pic\_22’. \*The problem I have is that they can’t do that cause then it will show all the pictures on a another page in a format and somewhere in the middle there will be one picture missing. So I somehow need all the values to shift one back when a picture gets deleted. So if someone deletes \*‘pic\_10’ _then_ ‘pic\_11’s’ \*value will shift into _‘pic\_10’s’_ place and so on. I hope you are following.

How do I go about this? I’m so confused :d: I would really appreciate and help or tips!