Changing a variable for every item in a MySQL Table

[kyles0623]

 

I am trying to create a simple CMS and when someone deletes an article I want to loop through all of the articles and make it in order. For example, is I have article numbers: 1,2,3,4,5 and I delete 4, then I want to loop through all the articles so it goes and change the article number so it goes 1,2,3,4 and not 1,2,3,5.

 

Help?

 

[ldb358]

UPDATE users SET id=id-1 WHERE id>$post_id

 

Where $post_id = the id of the post deleted

[PFMaBiSmAd]

You already have one thread for this problem, is there some reasons you started a second thread?

[kyles0623]

Thankyou so much. That worked perfectly.