RE: [PHP] Resetting ID in mySQL DB

2001-11-19 Thread Thomas Edison Jr.
should see what i mean... good luck jack -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 2:09 AM To: Jack Dempsey Subject: RE: [PHP] Resetting ID in mySQL DB Jack, Ok i get it! Lemme just go through the code once more

RE: [PHP] Resetting ID in mySQL DB

2001-11-11 Thread Jack Dempsey
say you have 100 records. you delete number 36. your db will then be ... 34 35 37 38 ... correct? after a delete, you could then say: update table set id_num=id_num-1 where id 36 and this would update all relevant records -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL