Re: [PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread Paul M Foster
On Sun, Sep 20, 2009 at 12:07:39PM +0430, Parham Doustdar wrote: > Hello there, > I'm guessing that when a row in a MySQL table is removed, the ID colomns of > the rows which come after that row are not changed. For example: > 1 > 2 > 3 > 4 > > Now, if I want to remove the third rows, the ID col

Re: [PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread tedd
At 12:07 PM +0430 9/20/09, Parham Doustdar wrote: Hello there, I'm guessing that when a row in a MySQL table is removed, the ID colomns of the rows which come after that row are not changed. For example: 1 2 3 4 Now, if I want to remove the third rows, the ID colomn would be something like:

Re: [PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread Phpster
On Sep 20, 2009, at 3:37 AM, "Parham Doustdar" wrote: Hello there, I'm guessing that when a row in a MySQL table is removed, the ID colomns of the rows which come after that row are not changed. For example: 1 2 3 4 Now, if I want to remove the third rows, the ID colomn would be so

Re: [PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread Ashley Sheridan
On Sun, 2009-09-20 at 01:06 -0700, Lars Torben Wilson wrote: > On Sun, 20 Sep 2009 12:07:39 +0430 > "Parham Doustdar" wrote: > > > Hello there, > > I'm guessing that when a row in a MySQL table is removed, the ID > > colomns of the rows which come after that row are not changed. For > > example:

Re: [PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread Lars Torben Wilson
On Sun, 20 Sep 2009 12:07:39 +0430 "Parham Doustdar" wrote: > Hello there, > I'm guessing that when a row in a MySQL table is removed, the ID > colomns of the rows which come after that row are not changed. For > example: 1 2 > 3 > 4 > > Now, if I want to remove the third rows, the ID colomn wou

[PHP] Question: Correcting MySQL's ID colomn when removing an entry

2009-09-20 Thread Parham Doustdar
Hello there, I'm guessing that when a row in a MySQL table is removed, the ID colomns of the rows which come after that row are not changed. For example: 1 2 3 4 Now, if I want to remove the third rows, the ID colomn would be something like: 1 2 4 I was wondering if there was a way to fix it thr