RE: [PHP] Auto Increment Problems....

2002-07-29 Thread cteubner
-Original Message- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Apart from this looking ugly, it poses another problem. In my PHP script where I can add new rows, I query the table, checking how many rows in the table altogether and set the new id as the next number, but this doesnt

[PHP] Auto Increment Problems....

2002-07-29 Thread Georgie Casey
rite, my primary key column (id) is set to auto_increment as usual which is very handy. But when I delete a row, the auto_increment just keeps incrementing and there's this 'hole' left where I deleted the row! Apart from this looking ugly, it poses another problem. In my PHP script where I can