Hello sir,

                It is a nice post .May you please help me for my following database related requirement .

Let there are two field   1. id--->auto increment or 1 increment serially.

                                  2.name-->varchar

       the requirement is  : if i delete a record ,it will  be  rearrenged.  Like there are 5 records from id 1...to 5.If i delete the 3rd one then the id's will be

rearrenged again from 1...to 4 . So,what should i do in this case.

Thanks.