need to update each records after record
Would anyone share with me a code that can be used for this logic.
If i delete from a x records, record u.I need to update each records after record u till record x.the updation need to be carried out for the auto_increment field.
I think of a logic like this.
If need to delete the record,it should take the records after it,issue update query or update and then delete the record mentioned ,insert the updated records to database.
please some one help me by sharing this logic's code...or with a better code.
thanking you in advance i remain