I asked here about deleting a row, thanks to u people i found it easy.
But know i have a new problem. my table has an "id"-primary key and autoincrement, when I delete lets say row number 2, the next id after 1 becomes 3.
1- server a-on
2- server b-on <--- delete
3- server c-on
=> 1-server a-on
3-server c-on <----- i want this one to be 2-server c-on
4-server d-on <----- and this one to become 3-server d-on
row deleting problem - primary key help
Moderator: General Moderators
row deleting problem - primary key help
Last edited by zmurf on Tue Feb 15, 2005 10:57 am, edited 3 times in total.
10x
10x timvw, i solved the problem in my code, but now i need to know how to put those auto increments in order.
yup
yes indeed, but look at phpmyadmin, i modified my id from there, so i guess it could be done
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: yup
As feyd said, it will become very annoiying and glitchy if you decide to alter your auto_incremented field. There is no reason you should have to anyways. Better off re-thinking your logic.zmurf wrote:yes indeed, but look at phpmyadmin, i modified my id from there, so i guess it could be done